topic Re: Dynamically hide or show a column in Qlik sense Table and Pivot chart in App Development

Dynamically hide or show a column in Qlik sense Table and Pivot chart

shounendra_kuls — Tue, 24 Oct 2017 13:11:04 GMT

Hello all,

We are having a requirement where in we want to conditionally hide a particular column from display of a pivot or a table report

We have implemented conditional calculation based on a field selected by a user, if the user does not selects that field then no calculation will be done and we are populating Null value.

Following code has been used :-

If (GetSelectedCount([Measures]) = 0 or WildMatch(GetFieldSelections([Measures]), '*Actuals*'), (Sum(Actuals) , Null())

However now we need to hide this column if the condition does not satisfies in the if expression.

Please suggest if you have some approach or you have used some extensions to implement the such a requirement.

Thanks in advance.

Shounendra Kulshreshtha

Re: Dynamically hide or show a column in Qlik sense Table and Pivot chart

shounendra_kuls — Mon, 20 Nov 2017 06:01:31 GMT

Well Did not get any reply, however we found a way to dynamically hide or show the column in a Pivot, if you can use the Pivot table instead of a normal one, then by adding the column to hide in column section of the Pivot.

The user can filter and hide the columns.

Re: Dynamically hide or show a column in Qlik sense Table and Pivot chart

eduardoheres — Thu, 16 May 2019 21:58:53 GMT

how did you do it?

Re: Dynamically hide or show a column in Qlik sense Table and Pivot chart

harsh44_bhatia — Thu, 24 Oct 2019 14:15:38 GMT

How did you get this. Could you please share some insight on this and on which QS version