topic Re: Enable Condition For Expression in QlikView

Enable Condition For Expression

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

I have to hide one expression out of 5 expression in straight table when ever a user perform some selection from the list object Business_L1 Or Business_L2

I tried below condition but its not working

GetSelectedCount([Sub - Business Line])<=0 or GetSelectedCount([Business Line L1])<=0

If I use only one condition then its working fine

GetSelectedCount([Sub - Business Line])<=0

Can some help me out with this

Many thanks in advance

Re: Enable Condition For Expression

sunny_talwar — Tue, 14 Feb 2017 11:07:06 GMT

Not sure I understand the point of using <= here? Count of selection can never be less than 0.

Also, do you need both to be not selected? May be use and

GetSelectedCount([Sub - Business Line])=0 and GetSelectedCount([Business Line L1])=0

Re: Enable Condition For Expression

jonathandienst — Tue, 14 Feb 2017 11:15:35 GMT

There is nothing syntactically wrong with the Or statement (assuming the field names are correct); this condition will evaluate to true if there is no selection in either or both of the fields. Perhaps you need an AND rather than an OR?

BTW - GetSelectedCount will never return a negative, so you can just test against 0 to see if there is a selection.

Re: Enable Condition For Expression

dsharmaqv — Tue, 14 Feb 2017 11:18:31 GMT

thanks sunny logical error i sholud have used AND