topic Re: Hide n Show on Dimension n Expression in QlikView

Hide n Show on Dimension n Expression

prma7799 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Experts ,

I need one help that is I have one straight table in that i have 2 dimension with (cyclic group) and 5 expression.

Simply I wanted to hide group2 dimension and Ach , Targ expression when user select brand dimension for else it will show dimension and expression.

Exp Output (when user select Brand)

Re: Hide n Show on Dimension n Expression

Anonymous — Tue, 22 May 2018 05:01:16 GMT

in the Arch and Targ condictional field, put this condition

=if( GetCurrentField("Group1") = 'Brand',0,1)

// meaning, if the current selected field in Group 1 is equal to brand put zero (hide)

you can expand to consider the two groups 1 & 2

=if( GetCurrentField("Group1") = 'Brand' or GetCurrentField("Group2") = 'Brand',0,1)

Re: Hide n Show on Dimension n Expression

jyothish8807 — Tue, 22 May 2018 05:15:06 GMT

Hi PM,

Please refer the attached.

Br,