Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
i'm trying to create a pivot table, where i want to see only the top 10 customers, based on the result in the last month (ranking done only on the last month result).
as dimensions, i have the Date and the Customer.
I'm currently using this formula to calculate the sum of orders:
=if(aggr(RANK(sum({$<[Date]={"$(=Max([Date]) )"}>}ORDERS),4),Date, Customer)<=10, sum(ORDERS))
It gives expected results for the last month, but " - " for the previous months.
Any idea how to solve this?
Thanks
You are most likely going to need to attach sample QVW file, so folks can review data model and all the other details in the application. The best I can do otherwise is point you to the Design Blog area on Community where you can search through those posts to see if you can find something there that may help:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett