Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Prabhu1204
Creator
Creator

Set Analysis IF statement

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 '

 

IDQualityPerformanceFrequency
1HighNoHigh
2LowHighNo
3MediumLowLow
4NoMediumMedium
5NoNoMedium

 

 

Expected out put

ID
1
2
4
5

 

Kindly Help

-Prabhu
Labels (1)
3 Replies
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
Contributor III
Contributor III

Perfectly @sunny_talwar 

qliksrikanth_0-1602098237079.png

 

Gabriel
Partner
Partner

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