Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
exfosteve
Partner - Contributor III
Partner - Contributor III

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
exfosteve
Partner - Contributor III
Partner - Contributor III
Author

Updated File

Brett_Bleess
Employee
Employee

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.