Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
ashrivastav2
Partner - Contributor
Partner - Contributor

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 (2)
3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

you can create a calculated dimension 

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

ashrivastav2
Partner - Contributor
Partner - Contributor
Author

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

ThePeterK
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