Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have the following calculated dimension for Customer Rank:
=If(Aggr(Rank(Sum([Turnover])),[Customer ID])<=10,dual('Top 10',1),dual('Other',2))
Now I would like to create another calculated dimension for Turnover Rank, the buckets are based on:
- 30k to 50+
- 20k to 30k
- 10k to 20k
- 5k to 10k
- 1k to 5k
hic how would I re-engineer the Customer Rank into a Turnover Rank.
Paul, Why cant we create the dimension in script?? I mean in script we can use if else clause adn create a field like you asked Turnover Rank.
It would work in the script for a static dimension, however, Turnover Rank is a dynamic calculation that will change based on user selections.
Would you be able to share some raw data and explain what the desired output needs to look like for the data provided?
The basic premise is to group customer sales into buckets. Unfortunately, cannot provide data as it is customer data, however, it is based on the following:
- Group sales into buckets based on the following ranges for customer:
So the end user can select a list for example, Jan-2017, and the sales buckets will reflect sales in each bucket based on customer.
It's basically the opposite of the calculation I posted earlier.
All I was asking for was dummy (mocked up) data... if providing that isn't possible, then I am not sure I will have a good understanding of what you have. May be someone else can offer better help