If statement

[wanyunyang]

In Qlik Sense, I have a table with two fields: Customer, Status. I only want to show those customers with status: open or paused.

My function for Customer dimension is like:

if(match(Status, 'open', 'paused'), Customer).  But it doesn't work. How can I fix this?

Thanks in advance!

[sunny_talwar · Accepted solution]

May be try this

Aggr(Only({<Status = {'open', 'paused'}>} Customer), Customer)

[PabloTrevisan]

Hi,

in this case, you can try to limit in WHERE clause.

LOAD
     Customer, Status

from ....

WHERE Status = 'open' and Status = 'paused';

If is in the application the expression works here.

=if(Match(Status,'open','paused'),Customer)

Note that you need to exclude null to only apears open and paused.

It help's ?

[wanyunyang]

Thank you Sunny! It works!

May I have one more question? If one customer has both open and paused status, will this function show them both?

[Chanty4u]

yes it will

[wanyunyang]

Thank you!