topic Re: Creating value buckets on existing field in QlikView

Creating value buckets on existing field

Anonymous — Wed, 12 Oct 2016 17:51:10 GMT

Hi All,

I am trying to create value buckets on an existing field. My field is 'VendorSpend' and I want the buckets like:

>50k

50k-250k

250k-500k

500k-1m

and so on.

Any help is much appreciated. Thanks

sunny_talwar — Wed, 12 Oct 2016 18:19:46 GMT

I am guessing that this would be a calculated dimension? May be like this:

Aggr(

If(Sum(VendorSpend) < 50000, Dual('<50k', 1),

If(Sum(VendorSpend) < 250000, Dual('50k-250k', 2),

If(Sum(VendorSpend) < 500000, Dual('250k-500k', 3),

If(Sum(VendorSpend) < 1000000, Dual('500k-1m', 4)))))

, Vendor)

ecolomer — Wed, 12 Oct 2016 18:20:29 GMT

See this:

rupamjyotidas — Wed, 12 Oct 2016 18:58:12 GMT

In Script:

Load *,

If((VendorSpend) < 50000, Dual('<50k', 1),

If((VendorSpend) < 250000, Dual('50k-250k', 2),

If((VendorSpend) < 500000, Dual('250k-500k', 3),

If((VendorSpend) < 1000000, Dual('500k-1m', 4))))) as VendorBracket

From XYZ

Anonymous — Thu, 13 Oct 2016 10:07:55 GMT

Thanks Rupam. Exactly what i wanted.

Anonymous — Thu, 13 Oct 2016 10:09:02 GMT

Thanks but i don't need summation.