topic Re: Hide column based on selections in QlikView

Hide column based on selections

Fri, 12 Jul 2013 22:30:45 GMT

I'm using this forumla to make a column go blank unless a certain item in my cyclic group is selected. Is there any way to hide the column completely in v10?

=if(GetCurrentField([Cyclic Group]) = 'Group Selection', [Column Name])

Re: Hide column based on selections

swuehl — Fri, 12 Jul 2013 23:34:15 GMT

If I remember correctly, there should be a conditional hide column option in presentation tab of chart properties (at least for a straight table?).

=if(GetCurrentField([Cyclic Group]) = 'Group Selection', 1,0)

Re: Hide column based on selections

jagan — Sat, 13 Jul 2013 05:01:57 GMT

Hi,

If you are using Qlikview 11, then you can use Enable Conditional option in Dimension tab and use this expression

=if(GetCurrentField([Cyclic Group]) = 'Group Selection', 1,0)

Hope this helps you.

Regards,

Jagan.

Re: Hide column based on selections

O11235 — Tue, 05 Jan 2016 14:56:05 GMT

Hi,

I've used this option ("conditional hide column option in Presentation tab of Chart Properties", except in Pivot Tables were the option is not available but one can move and hide columns instead) in QV 11. Useful in presenting extra fields for particular selections within the cycle group. How ever I've never used an 'if' statement just:

GetCurrentField([Name of the cyclic group] ) ='Name of the field within the cyclic group'

The conditional statement acts like an if statement and I vaguely recall once having problem using the if statement in such a conditional field within the Chart Properties - can't remember the details pertaining to that particular situation though so I stand corrected.