Recently at work, someone had a problem in assigning a consistent color to the dimension. For example, if a table consist of Products and Revenue then each Product should maintain a consistent color, irrespective of the selection. Suppose the table is as follows : A pie chart for the above table should maintain consistent colors for the Products i.e. BabyClothes should retain RGB(141,170,203),Sports […]
Learn QlikView
Dynamic title in Charts and Expressions – GetFieldSelections()
It is very important to have dynamic title in your Charts and Expressions because it gives context to your visualization and makes it easy for the users to understand the visualization clearly. It is very easy in QlikView to achieve this functionality I will create a simple straight table with some list boxes to show […]
Share this:
Custom Sort Order in QlikView
Load Order is very important in QlikView because it defines the default Sort Order of the fields and also default color order for values. In QlikView the Order of the Values reflects the load Order of the data. Load Order generally resembles “order of the source data” but it is not always the case. You […]
Share this:
Concatenate and NoConcatenate in QlikView – Part 1
In QlikView, if the number of fields and field names of two or more tables are same then the tables are Concatenated into one table. It usually happens when you are loading tables from different datasources and don’t realize that field names and field numbers in different tables are same. After the dataload you expect to see two […]
Share this:
Concatenate and NoConcatenate in QlikView – Part 2
In Concatenate and NoConcatenate in QlikView – Part 1 you saw how automatic concatenation occurs in QlikView. In this Part 2, you will see Forced Concatenation and how to prevent Concatenation i.e. NoConcatenation. Forced Concatenation If two or more tables do not have exactly same name and number of fields, it is still possible to […]
: