Discussion board where members can get started with Qlik Sense.
I want to rank the products based on the two measures (Sales and Actuals). With this expression, I was getting the following results. But what I was expecting is different. Can you please help me in building the right expression.
=if(aggr(rank(sum([Sales])),[Product ID])<= 3,'Top 3 Product Sales',
if(aggr(rank(sum([Actuals])),[Product ID])<= 3,'Top 3 Product Actuals'
Question Modified from above:
From the below sample table. I want to create the dimension expression pivot table. I considered using the ranking for this approach but I am not getting the results as expected.
sample data table:
Thanks in Advance,
Message was edited by: vidya sagar malla
Your dimension seems to return the expected results. I guess you are actually asking about the Rank expression?
How have you defined this expression? I would assume quite similar to your dimension?
Yes, I defined this expression. But I was not getting the results as expected resultset. I am developing this in a Qlik Sense.
and Yes i need a rank expression here.
Try this in expression not in dimension.
=if (rank (total (sum([Sales])))<= 3,'Top 3 Product Sales',
if (rank (total (sum([Actuals])))<= 3,'Top 3 Product Actuals'
The Expression is not working as expected. let me update the question with some sample data.