if condition

[jyothish8807]

Order No	Status	Product name
12	Open
13	close
14	In process
15	In process
16	close

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 · Accepted solution]

try this

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

or simply this

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

[MayilVahanan]

Hi

Try like this

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

or

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

Please refer the set analysis

[#4]

"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])