Set Analysis IF statement

[Prabhu1204]

Hi 

I have a Table chart in Qliksense as below, I need to have all the ID where the fields  Quality,Performance, Frequency has the value 'No '

ID	Quality	Performance	Frequency
1	High	No	High
2	Low	High	No
3	Medium	Low	Low
4	No	Medium	Medium
5	No	No	Medium

Expected out put

ID

1

2

4

5

Kindly Help

[sunny_talwar]

@Prabhu1204 Is this for an expression? May be this as your set analysis

{<Quality = {'No'}>+<Performance = {'No'}>+<Frequency = {'No'}>}

If this is for a dimension, then may be this

If(Quality = 'No' or Performance = 'No' or Frequency = 'No', ID)

[qliksrikanth]

Perfectly @sunny_talwar 

[Gabriel]

Hi,

An approach I will use is flag the Nos in the script.

If you want those fields as individuals then do something like this

IF (MATCH(Quality,'No')>0,1,0)   AS Flag_Qty_No // do same for each field

Then you can use the flag in your set analysis