topic if selected field then do expression1 else expression2 in QlikView

if selected field then do expression1 else expression2

vadim_grab — Tue, 24 Jul 2018 10:19:18 GMT

Hi, All.

I have a dashboard and filter with list of different analysis periods.

Analysis periods linked with list of expressions, which are using at dashboard like dynamic measure.

I need expression which will show default expression if filter value don't selected, or expression which linked with filter value.

I try with but without success

=if(GetSelectedCount(description)>0,$($(=PassengerAdultExprFieldCurrent)),$(ePassengerAdultExprFieldMTD))

Many thanks for you comments and advices!

Vadim

Re: if selected field then do expression1 else expression2

tresB — Tue, 24 Jul 2018 10:42:54 GMT

So somehow your second expression (variable expansion) is not working. Could you try putting it separately and see if it is independently working or not? Then, you can start troubleshooting may be the variable declaration.

Re: if selected field then do expression1 else expression2

vadim_grab — Tue, 24 Jul 2018 12:28:08 GMT

Hi, Tresesco B

They work excellent in other places, but do not in If statment dashboard...

Vadim

Re: if selected field then do expression1 else expression2

vadim_grab — Tue, 24 Jul 2018 12:39:08 GMT

true logic to use GetSelectedCount()?

Re: if selected field then do expression1 else expression2

vadim_grab — Wed, 25 Jul 2018 10:17:53 GMT

Maybe very interesting...

Expression don't work:

if(GetSelectedCount(description)>0,$($(=PassengerAdultExprFieldCurrent)),$(ePassengerAdultExprFieldMTD))

Expression work correct:

if(GetSelectedCount(description)=0,$(ePassengerAdultExprFieldMTD), $($(=PassengerAdultExprFieldCurrent)))

Logic is the same, the result is the opposite

Is it bug? Why first expr don't work? second - working correct?

Re: if selected field then do expression1 else expression2

tresB — Thu, 26 Jul 2018 05:23:30 GMT

I came across some posts saying - in QlikSense field selection functions had issues or did not work at certain areas (like, calculated dimension) in some earlier versions. Not sure, if this is something similar or not. I suggest you contact qlik support.