Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Conditional show for certain key figure

Hi QlikXperts!

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?

Any hints?

Your help is highly appreciated.

Thank you!

msglanges

3 Replies
MVP
MVP

Re: Conditional show for certain key figure

With QV11, you could set a conditon for each expression in expression tab. I think this would fit your needs.

Regards,

Stefan

edit: as condition you could use e.g.

=GetSelectedCount( Year )

Not applicable

Conditional show for certain key figure

Stefan,

thank you so far!

Unfortunately, QV10 is in use. Any options with QV10 ?

IAMDV
Honored Contributor II

Re: Conditional show for certain key figure

Hi,

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.

Let me know if you need more explanation.

Cheers - DV

Community Browser