Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobi
Partner - Contributor II
Partner - Contributor II

Change KPI in pivot table

Hi. Anyone who know if it is possible to exchange KPI in your pivottable.

 

Lets say you have 3 different columns:


Net sales 2019, Net sales 2018, Dev. 2019 Vs 2018 Net sales.

 

And you as a user just want to look on Cost 2019, cost 2018, dev. cost instead. Is there any way for this? And then I mean so that just net sales are visible first. And then you can change net sales to cost like you do with alternative measures in a chart.

 

 

Labels (1)
1 Reply
dplr-rn
Partner - Master III
Partner - Master III

You can use 'Show Column If' to hide/show appropriate columns.
e.g. use a button from dashboard bundle to set a variable. which controls the show and hide columns