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

How can group the dimensions

Hi team,

Need help from experts,

I want to know how to group one of the column and get results accordingly.

For example

   

NameProduction

 

1
2
3
4
5
6
7
8
9
10
11
12

  

927836
506706
937712
872839
729776
881868
750717
880725
557991
525797
559614
1000771

Lets say I want to present the above production from 1 to 5 individually  and then 6,7,8,9 would be clubbed as 6+

Please confirm what would be the syntax in expression or we would give condition in dimension.

May be new field to be created in scripting.

Kindly suggest at earliest

Regards

1 Reply
maxgro
MVP
MVP

1.png

LOAD

  *,

  if(Name<6,Name, if(Name<10, '6+', 'Other'))as NameGroup

INLINE [

Name Production Sale

1 927 836

2 506 706

3 937 712

4 872 839

5 729 776

6 881 868

7 750 717

8 880 725

9 557 991

10 525 797

11 559 614

12 1000 771

] (delimiter is spaces);