topic Display/Hide chart expression based on condition in QlikView

Display/Hide chart expression based on condition

Wed, 25 Nov 2020 16:16:04 GMT

I have a line chart with one dimension and two expression.

I defined a variable for each one like below:

IsVisibleExpr1 and its value = True

IsVisibleExpr2 and its value = False

then in expression condition I assign below values:

* For expression 1: =IsVisibleExpr1

* For expression 2: =IsVisibleExpr2

Independently of the variables values, all expressions are displayed. Why for example expression 2 is displayed if its value IsVisibleExpr2 is false?

Re: Display/Hide chart expression based on condition

beck_bakytbek — Wed, 27 Jul 2016 12:30:10 GMT

Hi Tony,

see this Topic to your issue; QlikView Conditionally showing and hiding the filters / objects - YouTube

i hope that helps

beck

Re: Display/Hide chart expression based on condition

Clever_Anjos — Wed, 27 Jul 2016 12:38:44 GMT

True/False are -1/0?

Re: Display/Hide chart expression based on condition

Anonymous — Wed, 27 Jul 2016 13:17:46 GMT

These two zip files will help you. they have the solutions with examples. Also go through this discussion where you have other examples and learning stuff.

Qlikview Learning: General topics with Examples and Help Material

Re: Display/Hide chart expression based on condition

sunny_talwar — Wed, 27 Jul 2016 14:02:08 GMT

Can you share a sample of what you have?

Re: Display/Hide chart expression based on condition

Wed, 27 Jul 2016 16:44:46 GMT

Thanks for guide me in the right direction. I have solved it by assigning 1 or 0 to variables instead of True/False.

For example:

IsVisibleExpr1 and its value = 1

IsVisibleExpr2 and its value = 0

then in expression condition I assign below values:

* For expression 1: =IsVisibleExpr1

* For expression 2: =IsVisibleExpr2

Re: Display/Hide chart expression based on condition

Wed, 27 Jul 2016 16:45:41 GMT

Thanks all by your suggestions and examples. I finally solved it by changing value from True/False to 1/0.

Re: Display/Hide chart expression based on condition

Clever_Anjos — Wed, 27 Jul 2016 17:24:56 GMT

Remember that true/false in Qlikview are merely :

0 - false

anything <> 0 - true