Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
madeleine_josef
Contributor

Where match

Hi,

Can you use a WHERE MATCH statement in an expression?

I tried the following: WHERE MATCH ( {$<OrderType={15}>} SupplierName )

But it didn't work.

I wanted the table to show the supplierNAme for all orders with type 15. Is there any other way to make this selection in a table?

Thank you!

 

1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: Where match

try this

if(OrderType=15,SupplierName )

2 Replies
arulsettu
Honored Contributor III

Re: Where match

try this

if(OrderType=15,SupplierName )

madeleine_josef
Contributor

Re: Where match

Thank you, it worked!