Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Dynamic change of Pivot table Dimension/Measure


I have a filter which has A, B and C values. If I select A then this should change the dimension attribute/column to 'A' column (I have a column with name 'A'), similarly, if I change to B, B column should get affect in pivot table visualization.

Along with that, how do we dynamically add few measure columns in pivot table based on filter selection.

If you could provide a sample screenshots or QVFfile it would be more helpful for the analysis.

3 Replies

Re: Dynamic change of Pivot table Dimension/Measure


You can't add or remove Dimensions and Measures in Sense dynamically, other than teaching your users to drag-and-drop Master Items from the library onto charts.

With a static number of Dimensions and Measures, you can make them dynamic using variables and $-sign extensions. Something like this:


vDim = only(Column)




Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!

Contributor III

Re: Dynamic change of Pivot table Dimension/Measure

Expanding Oleg's answer:

If you would like to make labels for such dynamic columns dynamic too - take look at one possible solution: Emulating dynamic labels in Qlik Sense

Honored Contributor II

Re: Dynamic change of Pivot table Dimension/Measure

Hi Kishore,

Adding and removing of fields is only possible in the edit view. You can only restructure the pivot table in the view mode.



Community Browser