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: 
_jonah
Contributor
Contributor

Qualify a data in field in data load editor

Hi -

I first unqualify three sets of database. Now, I have to qualify/exclude one database but only for two data in MONTH field. Would you know how to do this in the data load editor? I've been looking for an exact scenario here but didn't see any. 

Unqualify *;

Qualify "Month";

would it be possible..

 

Unqualify *;

Qualify "Month" = 'October','December';

 

Appreciate any help you could extend. Thank you.

2 Replies
Somasundaram
Creator III
Creator III

Hi,

 

We can able to do for column - Qualify/Unqualify.  It's not possible to do  Qualify "Month" = 'October','December';  


-Somasundaram

If this resolves your Query please like and accept this as an answer.
marcus_sommer

What you want to do is to flag the data and this could be done with something like:

...
if(match("Month", 'October','December'), 0, 1) as MonthFlag
...

and then you could use this flag-field within a listbox or used it as condition in expressions.

- Marcus