If condition within Set Analysis expression

[datashaw]

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.

[Lauri]

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

[datashaw]

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,

[Lauri · Accepted solution]

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

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

[datashaw]

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

[datashaw · Accepted solution]

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

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

[Lauri]

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

[datashaw]

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))

[Lauri]

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))