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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table selection issue

I have pivot table like below with 3 measure and one dimension

 

MeasureDimD1D11D12D2D21D22
M1423924444748
M2214739161730
M3193121332926

Now requirement is like,

when I select the D1, I just want to see D11,D12

when I select the D2, I just want to see D21,D22


Bydefault, I just want to see D1, D2

23 Replies
Digvijay_Singh

I know stalwar1 will conclude on my bug or QV bug

Kushal_Chawda

Sunny bhai iska koi easy solution batao

sunny_talwar

Yaar leaving for work, I will go through this and see if I can offer anything better than what you already have . If not, then call our guru

sasiparupudi1
Master III
Master III

Have a mapping table between the dimension values

t1:

Load * Inline

[

Dim,M1,M2,M3

D1,20,30,40

D11,21,23,45

D2,44,16,33

D12,30,12,23

D21,47,17,29

D22,47,17,29

];

t2:

load * Inline

[

NewDim,Dim

D1,D11

D1,D12

D2,D21

D2,D22

];