Discussion Board for collaboration related to Creating Analytics for QlikView.
I have two fields "Sales" and "SalesDate" in a chart.
The Dimension is "SalesDate" and the Expression is "Sum(Sales)".
I want to put a Reference Line for the Average Sales for the Top 10 SalesDates.
Can someone please assist me with this?
Go to Solution.
Use this expression:
rank(sum(Sales)) <= 10,
Thanks! That works perfectly.
If I wanted to take it a step further and only include the top sale days where the sales are more than 3000 sales?
rank(sum(Sales)) <= 10 and sum(Sales) > 3000,