Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Grouping

hi

i have  one   filed  like    Data:

                                     0-5

                                     5-10

                                    10-15

                                    20-25

                                   25-30

                                   30- 35

];

my output like     0-15  only

Tags (1)
1 Solution

Accepted Solutions
kumarnatarajan
Valued Contributor

Re: Grouping

Hi,

Use this dimension or script

Ex: =if(SubField(Range,'-',2)<=15,Dual('0-15',Range)) .

Find the attached file

3 Replies
kumarnatarajan
Valued Contributor

Re: Grouping

Hi,

Use this dimension or script

Ex: =if(SubField(Range,'-',2)<=15,Dual('0-15',Range)) .

Find the attached file

Not applicable

Re: Grouping

Hi ,

   Please use the below code in the where clause while loading the table.

Where   (SubField(Data,'-',1)>=0) and (SubField(Data,'-',2)<=15);

Regards

Yusuf

Not applicable

Re: Grouping

Thanks

Community Browser