Hide/show Pivot table dimension column depend on filter which user selected

[#1]

Hi,

I am new for QlikView, I want to Hide/Show Pivot table Dimension column depend on end user selection on other object.

For example(Please refer attached image for reference)

If "testId" selected by user in MultiBox, Pivot table should have testid column otherwise no need to show column "testID" in pivot table.

Same thing for Device and Channel.

[maxgro · Accepted solution]

if you want to show/hide columns in a chart depending on number of values selected in a field

have a look in the online help at

getselectedcount (FieldName [, IncludeExcluded])

Returns the current number of selected values in a field.

or similar functions (getpossiblecount)

and also here

Customizable Straight Table

to show/hide columns

[#3]

Thank you very much. This help me to solve this issue.

I added this function on Dimension "Enable Condition" box to show only if it is selected>0.

Appreciate your help.