Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Horizontal dimension in pivot table?

Let's say I have a pivot table with columns A, B, C, D, E and F. How would I write a dimensional expression so that A, B, C and D, E, F appear under separate horizontal labels. (See attached picture -- Label 1/Label 2 is what I want to create.)Screen Shot 2019-06-26 at 10.13.57 AM.png

Labels (4)
3 Replies
Highlighted
Partner
Partner

hi 

you can create a calculated dimension 

if(match(Field,'A','B','C')>0,'Label 1','Label 2')

Highlighted
Partner
Partner

Should something be typed instead of field? This expression isn't working for me

Highlighted
Creator
Creator

Are the categories literally A,B,C,D,E,F and won't change often?

This is a case where I would go to the data manager and add a new column containing the field I need to group, use the 'replace' functionality to group them, and reload it.

93/93