Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

Use this dimension or script

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

Find the attached file

View solution in original post

3 Replies
kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

Use this dimension or script

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

Find the attached file

Not applicable
Author

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
Author

Thanks