Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to create a button on Qlik View in order to select the top 10 customers.
Let' say that I have a field "Customer" and values can be: A, B, C, D ...
every week, I receive a report containing the "Revenues" for each of those customers.
I want to sum the revenues (all periods together) for each customer, and using a button select the top 10.
I don't want to use "Select in field" where field is "Revenues" because I really want to make the selection on the Customers, not on values.
Hope it's clear
Thank you
Try a Select in Field action for the Customers field with ='=rank(sum(Revenues))<=10' as search string
Try a Select in Field action for the Customers field with ='=rank(sum(Revenues))<=10' as search string