topic Layout Expression Problem in QlikView

Layout Expression Problem

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

Hello,

I have two expression for a chart

1) vActiveSubSheet ='Sheet-8-7' or $(vNP) = 1

2) =GetSelectedCount([Leavers ExitYear])=0

I have Chart - So, Here i want to write two expression in Layout Tab - Conditional ...

Is that possible? If possible, Please help me...

Two expressions are Important....

sunny_talwar — Wed, 15 Jun 2016 12:47:34 GMT

Anil - I am not sure I understand what you trying to do. Can you may be elaborate?

Anil_Babu_Samineni — Wed, 15 Jun 2016 12:53:02 GMT

Sunny,

1) vActiveSubSheet ='Sheet-8-7' or $(vNP) = 1

First graph is Active the Sheet

2) =GetSelectedCount([Leavers ExitYear])=0

Second Graph is Selection the Field..

What i want to Achieve here, If i am using one expression working fine when i am trying to use the second expression here the problem.

Remind two expressions are Imp..

Anonymous — Wed, 15 Jun 2016 12:53:03 GMT

in conditional you may enter

((vActiveSubSheet ='Sheet-8-7') or ( $(vNP) = 1)) and (GetSelectedCount([Leavers ExitYear])=0)

or do you need an or for second Expression?

((vActiveSubSheet ='Sheet-8-7') or ( $(vNP) = 1)) or(GetSelectedCount([Leavers ExitYear])=0)

Anil_Babu_Samineni — Wed, 15 Jun 2016 12:56:11 GMT

Thanks