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 TO DO GROUPING IN STRAIGHT TABLE?

HOW TO DO GROUPING IN STRAIGHT TABLE?GROUP.PNGGROUP2.PNG

IN THIS IMAGE : I WANT TO GROUP DMIN,RA, SV  UNDER AD AND DO ROLL UP.

CBU IS A DIMENSION.

CAN WE ACHIEVE THAT IN FRONT END?

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Not sure if you want  the same value for COD,COP,DOM or not, for different value

if(wildmatch(CBU,'DMIN','ERWIN'),'ECOM',Null()

     ,if(wildmatch(CBU,'DMIN','RA','SV'),'AD',

     ,if(wildmatch(CBU,'COD','COP','DOM'),'SomeValue',CBU)))


Same value


if(wildmatch(CBU,'DMIN','ERWIN'),'ECOM',Null()

     ,if(wildmatch(CBU,'DMIN','RA','SV,'COD','COP','DOM''),'AD',CBU))

View solution in original post

14 Replies
stigchel
Partner - Master
Partner - Master

You can add a calculated dimension like this:

=if(CBU='DMIN' or CBU='RA' or CBU='SV','AD',CBU)

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

You have 3 choices . I prefer #2 below.

1. Hard coded Dimensional expression.

if(wildmatch(CBU,'DMIN','RA','SV'),'AD',CBU)

2. On the fly Custom Groups (With IE Plugin & Ajax) - No Macros

Users can map/group dimensions at run-time!

3. On the fly (Only in IE) with Macros

grouping dimension values

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.


Thanks,

Phani

Not applicable
Author

Hi Piet,

I have some rows like ERWIN AND ECOM, which i dont want them. how should I add that to statement

.

one more question :

I need to do same for COD, COP,DOM

how should i add that to this statement

=if(CBU='DMIN' or CBU='RA' or CBU='SV','AD',CBU)  

Not applicable
Author

stigchel
Partner - Master
Partner - Master

Not sure if you want  the same value for COD,COP,DOM or not, for different value

if(wildmatch(CBU,'DMIN','ERWIN'),'ECOM',Null()

     ,if(wildmatch(CBU,'DMIN','RA','SV'),'AD',

     ,if(wildmatch(CBU,'COD','COP','DOM'),'SomeValue',CBU)))


Same value


if(wildmatch(CBU,'DMIN','ERWIN'),'ECOM',Null()

     ,if(wildmatch(CBU,'DMIN','RA','SV,'COD','COP','DOM''),'AD',CBU))

Not applicable
Author

ECOM AND ERWIN

i DONT WANT THEM

stigchel
Partner - Master
Partner - Master

I see I misplaced a bracket

if(wildmatch(CBU,'DMIN','ERWIN','ECOM'),Null()

     ,if(wildmatch(CBU,'DMIN','RA','SV'),'AD',

     ,if(wildmatch(CBU,'COD','COP','DOM'),'SomeValue',CBU)))


Hope it helps

Not applicable
Author

IN THE SAME EXAMPLE I WANT TO SORT THE DISPLAY:

RA

SV

DMIN

COD

CSM

ITSM

UIM

EMO

APM

DOM

API

EMM

MF

WA

AUTO

IN THIS ORDER

Not applicable
Author

GROUP2.PNG

CAN I VIEW IT SIMILAR TO THIS EXCEL FILE

IF I CLICK ON +

CAN I VIEW THE ROLL UP FIELDS

GROUP3.PNG