topic Re: Grouping By Dollar Value in QlikView

Grouping By Dollar Value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Grouping By Dollar Value

sunny_talwar — Mon, 30 Oct 2017 17:43:00 GMT

Grouping how? Revenue per Customer? Revenue per Year? or just individual rows of revenue?

Re: Grouping By Dollar Value

sunny_talwar — Mon, 30 Oct 2017 17:49:47 GMT

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:

Buckets

Re: Grouping By Dollar Value

Anonymous — Tue, 31 Oct 2017 20:46:56 GMT

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?

Re: Grouping By Dollar Value

sunny_talwar — Tue, 31 Oct 2017 22:02:43 GMT

Again it would depend on which level are you wanting to do it at? Row Level? One dimension level? Multiple dimensions level?

Re: Grouping By Dollar Value

Anonymous — Wed, 01 Nov 2017 11:40:26 GMT

What do you mean by multiple dimensions level? Is that multiple categories?

Re: Grouping By Dollar Value

sunny_talwar — Wed, 01 Nov 2017 13:10:48 GMT

Would you be able to share a sample with expected output?

Re: Grouping By Dollar Value

Anonymous — Wed, 01 Nov 2017 15:31:37 GMT

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

Re: Grouping By Dollar Value

sunny_talwar — Wed, 01 Nov 2017 15:37:48 GMT

I was looking for a numerical data with specific output you look from that raw data