3 Replies Latest reply: Jan 18, 2012 12:41 PM by Deepak Vadithala RSS

    Conditional show for certain key figure

    Steffen Lange

      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