Discussion Board for collaboration related to QlikView App Development.
Like we do in Bar Charts - sort Descending on Count of Calls & in presentation tab, restrict only top 10 counts with "Max Visible Number".
I want to do the same in Pivot and Straight Chart.
How to achieve this? Pls Suggest!!
On the sort tab choose sort by expression and enter:
and choose descending.
In the presentation tab choose your max amount.
Create a Calculated dimension
If your dimension is product then your calculated dimension would be
Make sure the expression is sorted desc by y value and that you suppress when value is null