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

Hello,


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
MVP
MVP

Re: Dynamic change of Pivot table Dimension/Measure

Hi,

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:

Variable:

vDim = only(Column)

Dimension:

$(vDim)

Cheers,

Oleg Troyansky

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

vadimtsushko
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

reddys310
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.

Thanka,

Sangram.

Community Browser