Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

Dimensions

Hello,

Currently, I have Review Is Needed as a Dimension, but I would like the headers to be the Review Needed results and group them as the second picture. 

 

  Current ViewCurrent ViewDesired ViewDesired View

 

4 Replies
Vegar
MVP
MVP

I would suggest you to read @hic  old blog post about The Generic Load  in order to solve your issue.

jheasley
Creator III
Creator III

you could try Adding a column in the data, something like:

'Review Needed' as "Review Category"

This will give you the same dimension value for every record, then you can use the existing field as the second layer in the pivot table. 

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Added screenshots on top of @jheasley post:

Output:

MC2.PNG     

Chart Properties:

 MC.PNG

Add in measure after adding your 'Review Needed' as Column.

 

danieldors
Contributor III
Contributor III
Author

Much appreciated worked well.