Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Bucketing Data via Variables

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

 

 

 

 

2 Replies
Highlighted
Partner
Partner

Re: Bucketing Data via Variables

Updated File

Highlighted
Digital Support
Digital Support

Re: Bucketing Data via Variables

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/Scrip...

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

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.