Discussion Board for collaboration on QlikView Layout & Visualizations.
We need to hide a column dynamically based on dimension value using pivot table in QlikView 11
When on pivoting Dimension-3 over the measures horizontally, system should show the measure 1 column when dimension-3 value is Y and should hide the measure 1 column when dimension-3 value is N.
Any suggestion is appreciated.
in your dimensions
use calculated dimension
check the option supress when value is null.
Thanks for your timely response.
But forget to mention that dimension 3 will have multiple values, in this case how to supress.
If we execute the below mention script then measure 2 will get disappear