topic Re: Bucketing Data via Variables in QlikView

Bucketing Data via Variables

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

So I've got the data summarized the way I want (site Summary Table). Now I want to bucketize the data based on some variables, and I'm not quite sure how to do it.

There are 5 buckets to create per both the frequency and amplitude (<f1, f1 to f2, f2 to f3, >f3), and then I want use the different combinations (25 possible) to be the primary dimension, and then count sites with that combination of buckets.

Frequency Bucket, Amplitude Bucket, Count of Sites?

Any ideas on how to do this?

Thanks

Re: Bucketing Data via Variables

exfosteve — Thu, 18 Jul 2019 22:56:18 GMT

Updated File

Re: Bucketing Data via Variables

Brett_Bleess — Wed, 14 Aug 2019 14:48:31 GMT

Steve, have a look at the following links, I think this may get you on the right track and it may be easier this way:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/IntervalMatch.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/IntervalMatch_(Extended_Syntax).htm

Here is a Design Blog post on the function too that might help as well:

https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

Regards,
Brett