Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ashrivastav2
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 (3)
3 Replies
lironbaram
Partner
Partner

hi 

you can create a calculated dimension 

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

ashrivastav2
Partner
Partner
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