Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III

Replace Bucketing with intervel match

Hii,I have Aging wise bucketing.

Like,

if(age>=01 and age<=20,1,

if(age>=21 and age<=40,2,

if(age>=41 and age<=60,3,

if(age>=61 and age<=80,4,

if(age>=81 and age<=100,5,

if(age>100,6,0))))))


So I want to do it with or replace it with Interval match However I can do this using interval match ??

In qlikview we can replace Bucketing with Interval Match. so can anyone help me ?

3 Replies
Gysbert_Wassenaar

You'd have to create an extra table with the intervals and the values 1 through 6 you assign the buckets. Then you can use the intervalmatch with that table and the age field from your other table.

But why not simply use rangemin(ceil(age/20),6) instead.


talk is cheap, supply exceeds demand
dhavalvyas
Contributor III
Contributor III
Author

Can you share one of the example for it ??

tajmohamed30
Creator III
Creator III