Discussion Board for collaboration related to QlikView App Development.
I have a problem trying to display the top 5 values per month in a chart. The challenge is due to the fact that the dimension names associated with the highest value can change every month.
I would like the chart to display similar to this, with the dimension Country showing only in top 5 order each month, based on the calculated expression Units.
Currently my table is showing like this, and can only be sorted by month individually.
The basic expression I'm using for each month is as follows:
Is there a way to rank countries for each month separately and have the fields display accordingly?
Thanks very much.
I have been trying to find a solution to this, but with no success so far.
Does anyone have any suggestions?
try the below expression
Thanks for the susggestion. Unfortunately, this expression is not returning any values however.