Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil-kumar5
Creator II
Creator II

Pivot table dynamic change in dimensions

Hi Community,

 

Is it possible to change the dimensions of pivot table dynamically or we can click on header and that particular dimension shows in row header?

Like below example:

Row Labels             0-30             31-60         61-90    Grand Total

Zone-127  27
Zone-10  4949
Zone-2 11 11
Zone-3  1010
Zone-423  23
Zone-5 14 14
Zone-6  2323
Zone-727  27
Zone-8 10 10
Zone-9  3030

 

In the same manner if I click to State then it should change per below.

Row Labels          0-30             31-60        61-90         Grand Total

Delhi27101047
Haryana27 3057
Mumbia 25 25
UP23 7295

 

Please advise.

Thanks

1 Reply
raji6763
Creator II
Creator II

hi @sunil-kumar5 ,

please find attached QVF file

you can achieve this in two ways

  1. using Variable input button
  2. drill down(if you want to dril up Zone-->State)

 

output:

raji6763_0-1597408993742.png

 

 

Regards,

Raji