topic Re: If statement in Visualization and Usability

If statement

wanyunyang — Tue, 24 Jul 2018 16:41:42 GMT

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 — Tue, 24 Jul 2018 16:46:06 GMT

May be try this

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

PabloTrevisan — Tue, 24 Jul 2018 16:59:04 GMT

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 — Tue, 24 Jul 2018 18:13:18 GMT

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 — Tue, 24 Jul 2018 18:15:53 GMT

yes it will

wanyunyang — Tue, 24 Jul 2018 18:17:03 GMT

Thank you!