Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi -
I am trying to write an expression where in a bar chart i am only displaying top 15 Sales by region and sales people.
I tried ranking but i cant get the formula to work.
Dim 1 - Region
Dim 2 - Sales Person
Measure - Sales
Please help
Thank you!
You can use the "Dimension Limits" tab on chart's properties.
I dont see that option, where would i find it?
Upgrade to Qlikview Desktop 11.
Is there way to do this without an upgrade?
In chart properties, go to the tab presentation incorporates a limit on the size, but disables of the scroll
if(rank(aggr(sum(Sales), Region, [Sales Person]))<=15,
aggr(sum(Sales), Region, [Sales Person]))
This worked!
By any chance would you know how i can filter this expression to only display two regions and rank sales in order (Highest to lowest)?
thank you
if(rank(aggr(sum({<Region = {'Region1','Region2'}>} Sales), Region, [Sales Person]))<=15,
aggr(sum({<Region = {'Region1','Region2'}>} Sales), Region, [Sales Person]))
You can configure orders in Order Sheet of object properties.
Could you mark the answer to close this discussion, please?
Thank you,
Regards.
For some reason this formula does not work for me.
What would the best way to filter on the two reions? Create a separate dimension?