topic Re: if condition in QlikView

if condition

jyothish8807 — Tue, 06 Aug 2013 09:47:04 GMT

Hi,

I have three columns:

Order No , Status , Product name.

I want to display all those product name whose status is "Open" and "In process" only in a straight chart.

Regards

er_mohit — Tue, 06 Aug 2013 09:50:27 GMT

try this

aggr(only({<Status*={'Open','In Process'}>}Productname),[Order No])

or simply this

only({<Status*={'Open','In Process'}>}Productname)

MayilVahanan — Tue, 06 Aug 2013 09:52:54 GMT

Try like this

= Only( {<Status = {'Open', 'In Process'}>} ProductName)

= If( wildmatch(status, 'Open', 'in process'), ProductName)

Please refer the set analysis

Tue, 06 Aug 2013 10:22:02 GMT

"Open" and "In process"

Using Set Analysis:-

1. aggr(only({<Status*={'Open','In Process'}>}Productname),[Order No])

2. only({<Status*={'Open','In Process'}>}Productname)

Without Set Analysis

If(Status='Open' or Status='In process',Productname)

If(Status='Open' or Status='In process',[Order No])