I wonder if there is an "out-of-the-box" functionality to only show a selected KPI in a pivot table, when there is a certain condition fulfilled.
As an example, I don't want to show the KPI "estimated income" when there is a selection on a certain dimension, for example "year".
But other KPIs in the pivot table should always be shown, so it is NOT an option to hide the whole pivot table
If there is no out-of-the-box functionality provided by QlikView, does anybody have an idea how a workaround could be implemented? Maybe show white text color on white background, when a year is selected or something like that?
In QV 10, I have used a variable and macro (VB Scripting) to toggle enable/disable the expression. I have used variable triggers based OnChange event and calling the macro to control the enable/disable setting. I’m attaching an example... In this example if you select the region the first expression will disabled and enabled. But you can change your condition to something else
I hope this helps you to adapt for your requirement.