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?

14 Replies
stigchel
Partner - Master
Partner - Master

For the sorting I think you can use in the sort tab of the properties, sort by expression something like

=wildmatch(CBU,'RA','SV',......othervalues)

stigchel
Partner - Master
Partner - Master

For the +sign option, use a pivot table with two dimensions, the first where you do the grouping, second dimension CBU.

For clarity, can you please make a new thread for new questions?

Not applicable
Author

OK

Not applicable
Author

Can you explain in more detail.

stigchel
Partner - Master
Partner - Master

Not sure for what you want more detail... but in general tab change the chart to pivot table instead of straight table, then the first dimension with the grouping expression and then add a second dimension with field CBU