Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am very new to Qlikview and I'm struggling with some basic chart creations.
I would like to create something similar to the sample Salesforce.com app that you can find in Qlikview demos.
Basically I want to display the top 5 objects in each category/dimension, but I'm not
sure how exactly to code that.
For example:
There should be a listbox with the top 5 sales reps, top 5 schools, top 5 cities etc.
I know that you can go to the "dimension limits tab when creating a chart , but, unfortunately
that doesn't seem to work for listboxes.
Thanks!
Hi,
Try this expression in your listbox dimesion.
= if (aggr (rank(sum(Sales)), Item)<=2 , Item)
see the attchment for the reference.
Regards,
Nirav Bhimani