topic Re: intervals in QlikView

intervals

Wed, 25 Nov 2020 16:16:04 GMT

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

Anil_Babu_Samineni — Wed, 19 Oct 2016 17:31:13 GMT

You can create using valuelist

Bucket / interaction match

sunny_talwar — Wed, 19 Oct 2016 17:31:43 GMT

use if statement or class function

rupamjyotidas — Wed, 19 Oct 2016 17:55:57 GMT

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

MarcoWedel — Wed, 19 Oct 2016 23:09:51 GMT

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 — Thu, 20 Oct 2016 04:50:49 GMT

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:-

Thanks,