Solved: Re: intervals - Qlik Community

Report Inappropriate Content · ‎2016-10-19

Hi Experts,

i have to create a list box which enables selection of metrics grouped in intervals of 2 (1-2, 3-4, 5-6).

How to do this. can anyone please explain with example

sunny_talwar · ‎2016-10-19

use if statement or class function

Class Function Example

View solution in original post

Anil_Babu_Samineni · ‎2016-10-19

You can create using valuelist

Or

Bucket / interaction match

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sunny_talwar · ‎2016-10-19

use if statement or class function

Class Function Example

rupamjyotidas · ‎2016-10-19

I really like to create the Buckets in the script when possible to maintain the simplicity of the Application.

MarcoWedel · ‎2016-10-19

Hi,

one solution might be:

LOAD *,
    Dual(Floor(Value,2,1)&'-'&(Floor(Value,2,1)+1),Floor(Value,2,1)) as ValueGroup;
LOAD RecNo() as Value
AutoGenerate 30;

hope this helps

regards

Marco

Anonymous · ‎2016-10-20

Hi Rajendran,

You can use class() function here, it will create a bucket and separate your values according to the intervals.

Following are the examples for class function:-

class( var,10 ) with var = 23 returns '20<=x<30'
class( var,5,'value' ) with var = 23 returns '20<= value <25'
class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

Thanks,