Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Filter pane dimension

Dear all,

I have a field called Abnormal which has the data 'H','L',' '

Now i want to drive a field called Normality based on the condition

1.if Abnormal is 'H','L' then the data should be 'Abnormal'

2.if Abnormal is ' ' then the data should be 'Normal'

Expected output:

Normailty

Abnormal

Normal

I used this if(subfield(Abnormal,',')='','Normal','Abnormal' ) as Normality but i am getting some null values also  in Normality field.

Regards,

Joshua.

14 Replies
bhaskar_sm
Partner - Creator III
Partner - Creator III

Hi,

since you have null values in abnormal fields that way its not getting excluded from the condition that we are trying to imply..

if you want to replace the null values of Abnormal fileds with Nomal values try below.

testt.PNG

if(len(subfield(Abnormal,','))=0 OR Abnormal='' , 'Normal','Abnormal' ) as NormalityF

ajsjoshua
Specialist
Specialist
Author

Hi Sagar,

It doesn't works.

ajsjoshua
Specialist
Specialist
Author

Dear bhasker,

still i am getting null values.

ajsjoshua
Specialist
Specialist
Author

Dear Max,

It doesn't works.

bhaskar_sm
Partner - Creator III
Partner - Creator III

Hi,

PFA, script and app

NoConcatenate

FINAL:

Load

*,

if(len(subfield(Abnormal,','))=0 OR Abnormal='' , 'Normal','Abnormal' ) as NormalityF

Resident patient;

Drop Table patient;