Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
_jonah
New 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
Contributor III

Re: Qualify a data in field in data load editor

Hi,

 

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


-Somasundaram
MVP & Luminary
MVP & Luminary

Re: Qualify a data in field in data load editor

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