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
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
niha
Creator II
Creator II

Filtering out Column in Qliksense Preceding Load

Hello,

I have a very silly and simple question.  I am filtering some column in preceding load. 

My requirement is :  Financial Responsible Indicator is equal to / is Y, AND Paid Claim Indicator is equal Y, AND NIA Financial Flag is equal N, AND Funding Arrangement Description is equal to NOT APPLICABLE , FULLY FUNDED PLAN

so I filter out with these code:

WHERE [Financial Responsible Indicator]= 'Y'
OR [Paid Claim Indicator]= 'Y'
OR [NIA Financial Flag]='N'
OR [Funding Arrangement Description]= 'Fully-Funded '
OR [Funding Arrangement Description]= ' Not Applicable  ';

But It is not filtering out Properly and when I am doing with AND I am not getting any value. Please suggest.

Regards,

Niha

2 Replies
Vegar
Partner
Partner

It looks right.
I often add the where criterias as temporary fields in my output table and comment out my where criteria to check my output.

LOAD
....
[Financial Responsible Indicator]= 'Y' as _checkFRI,
[Paid Claim Indicator] = 'Y' as _checkPCI,
[NIA Financial Flag]='N' as _checkNIAFF,
[Funding Arrangement Description]= 'Fully-Funded' as _CheckFADFullyFunded
[Funding Arrangement Description]= ' Not Applicable' as _CheckFADNotAppl
FROM ...
WHERE
//WHERE [Financial Responsible Indicator]= 'Y'
//OR [Paid Claim Indicator]= 'Y'
//OR [NIA Financial Flag]='N'
//OR [Funding Arrangement Description]= 'Fully-Funded '
//OR [Funding Arrangement Description]= ' Not Applicable '
;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Gysbert_Wassenaar

If all the conditions must be met then you should use AND instead of OR.

But 'NOT APPLICABLE' is not the same as 'Not Applicable '. Those two values are two different values because the first in completely upper case and also because it does not contain a trailing space. Make sure to use the exact case sensitive values that should be used to compare the field values with.


talk is cheap, supply exceeds demand