Nulls in Alternate States Function.

[MuraliPrasath]

Hi Qlik,

I've used Alternate States  and get null values in following  expression. Can someone help me on this to avoid nulls? 

=only({[Target]}if([Status]='Yes','Yes',
if([Status]='No','No',
if(isnull([Status]),'No',
'No'))))

[Vegar · Accepted solution]

Try to switch places between the if and the only. 

If you are able to simply the expression it could end up like this:

If(only({[Target]}Status) ='Yes', 'Yes', 'No') 

[MuraliPrasath]

Thank you so much for your hint 👍. It works as if I expected. You saved my time and energy.