topic If condition within Set Analysis expression in App Development

If condition within Set Analysis expression

datashaw — Sat, 16 Nov 2024 05:42:02 GMT

Can you please help to me to write the below if condition inside the set analysis please

Set Analysis Expression =

Count({< STATUS ={'Rejected'}, TYPE ={'RTP'}>} Items)

IF Condition:

=if( Switcher = Payer, Switcher ,null()).

on above if Condition all are column names

Basically I want to show this on the KPI in Qlik Sense.

I appreciate if you could help me to resolve the issue.

Re: If condition within Set Analysis expression

Lauri — Thu, 30 May 2019 15:39:57 GMT

Are you using IndirectPayer as a dimension in your KPI? Or are you limiting the Items that get counted?

Re: If condition within Set Analysis expression

datashaw — Thu, 30 May 2019 16:07:10 GMT

This is just a KPI numbers on the dashboard there no Dimension.

*Just limiting the items to get counted

Please correct my set analysis part with if condition

Count({< '*IF condition here' , STATUS ={'Rejected'}, TYPE ={'RTP'}>} Items)

=if( Switcher = Payer, Switcher )

Field names:

Switcher = Santander, Barclays, City, Lloyds, HSBC...etc

Payer = HSBC, Habib, Natwest, City, TSB, Santander.... etc,

Re: If condition within Set Analysis expression

Lauri — Thu, 30 May 2019 16:48:01 GMT

You can't write IF inside of set analysis, only outside:

If(Switcher=Payer, Count({<STATUS ={'Rejected'}, TYPE ={'RTP'}>} Items))

Re: If condition within Set Analysis expression

datashaw — Thu, 30 May 2019 21:23:07 GMT

Thanks for the reply Laurischarf, I would expect the result would be 3-5 digit Number, but it does not show anything just an '-' on the KPI

Re: If condition within Set Analysis expression

datashaw — Thu, 30 May 2019 21:32:40 GMT

I found the answer... Thanks for the help 🙂

Count({<STATUS ={'Rejected'}, TYPE ={'RTP'}>} If(Switcher=Payer, Items))

Re: If condition within Set Analysis expression

Lauri — Thu, 30 May 2019 21:44:17 GMT

Of course! Sorry for my error. Glad you figured it out.

Re: If condition within Set Analysis expression

datashaw — Fri, 31 May 2019 10:23:28 GMT

But in the if statement how do i avoid nulls
is that something like this..? please correct

Count({<STATUS ={'Rejected'}, TYPE ={'RTP'}>} If(Switcher=Payer -= "=Null()" , Items))

Re: If condition within Set Analysis expression

Lauri — Fri, 31 May 2019 13:09:25 GMT

No, you have to put all set analysis statements between { }. Are you getting Items where Switcher and Payer are Null? I would expect the If statement to remove them, because Qlik doesn't consider Null a value, so when Switcher and Payer are Null, they are not equal. They are nothing.

Still, you can make sure to get only values using a wildcard, like this:

Count({<STATUS ={'Rejected'}, TYPE ={'RTP'}, Switcher={'*'}>} If(Switcher=Payer, Items))

Or do it in the If, but they say performance is better with set analysis.

Count({<STATUS ={'Rejected'}, TYPE ={'RTP'}>} If(Switcher=Payer and Len(Switcher)>0, Items))