topic Re: Hide/show Pivot table dimension depend on filter which user selected in QlikView

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

Fri, 28 Mar 2014 00:00:56 GMT

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 — Fri, 28 Mar 2014 00:11:26 GMT

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

to show/hide columns

Fri, 28 Mar 2014 00:19:59 GMT

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.