QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik! QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Valued Contributor III

What are Total , All Qualifiers (Keywords)...

All Qlik Beginners,

Here Iam with some more tasks from a beginner point of view.

1. Show the percentage of individual items in the whole items taking selections into count

2. Show the percentage of individual items in the whole items with out taking selections into count

3. Show the percentage of each SalesmanID sales in its respective product

4. In a table show the top SalesmanID sales in its respective ProductID for all other rows

5. In a table show the top SalesmanID in its respective ProductID for all other rows

Definition:

Total and Allare two keywords used in Qlik view to do a variety of things.For eg

SNOData
1100
2200
3300
4400

In the above table I want another column with Data% as below

110010.00%
220020.00%
330030.00%
440040.00%

In the above table Data% column can be achieved by using

1.Sum(Amount) as expression using relative option  with number format as Expression Default

2.Sum(Amount) / Sum(TOTAL Amount) with number format as fixed and show in percentage check box ticked

3.Sum(Amount) / Sum(ALL Amount) with number format as fixed and show in percentage check box ticked

Then what is the difference between Total and All ??

For eg Select Sno's 1 , 2 observe the percentages they show as below

The percentages are now based on the selected SNO's total i.e., 300, if you still want to have percentages on the whole SNO's even after selection then use Sum(Data)/ Sum(ALL Data) as expressions and the percentages would be as follows

Hope I am clear.

Miscellaneous: Try Relative option with Dimension limits for further delving.

Even Total and All behave differently when dimension limits is used.

Want more....

Kiran Kumar

Labels (1)