Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
shanu_s9
Contributor III
Contributor III

Pivot table Dimensions based on sub fields and expressions

Hello Experts,

I want to display my data in the below format, but i count not able to see any such object.
here AD has direct values and TOP VIEWER & BOTTOM VIEWER have different areas data need to display like this. I have around 6 or 7 dimension info need to show same way based on areas.

Any extension/ method can display in qlik sense please suggest and help me.

Thanks in advance.

 

AD TOP VIEWER BOTTOM VIEWER
Area1 Area2 Area3 Area1 Area2 Area3
             
             
             
             
Labels (1)
  • Chart

4 Replies
Or
MVP
MVP

This looks like a standard pivot table. What exactly is the problem you are facing?

Or_0-1681734648777.png

 

Kushal_Chawda

are top viewer and bottom viewer present in data? Probably sample data would help

shanu_s9
Contributor III
Contributor III
Author

Thank you for your support,

If I add one dimension it is coming as expected, but when i add 2nd dimension then it is going under 1st dimension and values 

 

Example: expecting

Alpha  |     Beta

A | B| C|  E| F| G

But coming as 

Alpha

Beta

A| B|C|D|E|F

 

Or
MVP
MVP

Drag it to the left of "Values" (or vice versa).