Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking to organize my data by groups by revenue. The revenue is the only calculated field. The groups I am working with are as follows:
0-100
100-300
300-500
500+
Any idea as how to tackle this? I'm still very new to Qlik code and syntax.
Thanks
Assuming Revenue by XYZ field, you can try this to create your buckets on the front end
Aggr(
If(Sum(Revenue) < 100, Dual('0-100', 1),
If(Sum(Revenue) < 300, Dual('100-300', 2),
If(Sum(Revenue) < 500, Dual('300-500', 3), Dual('500+', 4)))), XYZ)
Also, look here:
Grouping how? Revenue per Customer? Revenue per Year? or just individual rows of revenue?
Assuming Revenue by XYZ field, you can try this to create your buckets on the front end
Aggr(
If(Sum(Revenue) < 100, Dual('0-100', 1),
If(Sum(Revenue) < 300, Dual('100-300', 2),
If(Sum(Revenue) < 500, Dual('300-500', 3), Dual('500+', 4)))), XYZ)
Also, look here:
Thanks for the response. That worked perfectly. If I wanted to make these same categories on the back end to apply to multiple tables or sheets how would I go about that?
Again it would depend on which level are you wanting to do it at? Row Level? One dimension level? Multiple dimensions level?
What do you mean by multiple dimensions level? Is that multiple categories?
Would you be able to share a sample with expected output?
Something like this. Two tables:
Rev Cat | pre policy change | post policy change |
0-100 | order qty | order qty |
100-300 | order qty | order qty |
300-500 | order qty | order qty |
500+ | order qty | order qty |
Rev Cat | pre policy change | post policy change |
0-100 | Total $ orders + Fees | Total $ orders + Fees |
100-300 | Total $ orders + Fees | Total $ orders + Fees |
300-500 | Total $ orders + Fees | Total $ orders + Fees |
500+ | Total $ orders + Fees | Total $ orders |
I was looking for a numerical data with specific output you look from that raw data