Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
hbleby96
New Contributor II

How to select entries that aren't valued in a list box?

Hi!

So I have some data at document number level and there are thousands of document numbers.

I have a list of document numbers that I have left joined to a "Flag" so I can select it in my Qlikview.

However, is there a way to select all document numbers that aren't flagged?

If you need anything else, let me know, I've attached a little example

Thank you in advance

1 Solution

Accepted Solutions
vamsee
Valued Contributor

Re: How to select entries that aren't valued in a list box?

Use Applymap() instead of Join

Flag_Map:

Mapping LOAD CoCd &'|'& DocumentNo as Key,

               Flag

FROM

(ooxml, embedded labels, table is Data);

Data:

LOAD

                CoCd,

               DocumentNo,

                Amount,

                Applymap('Flag_Map', CoCd &'|'& DocumentNo ,'NO') as Flag

FROM

(ooxml, embedded labels, table is QV);

3 Replies
neelamsaroha157
Valued Contributor II

Re: How to select entries that aren't valued in a list box?

If the flag is a column in your data source then may be you can use the below condition to replace '-' with some value like 'No' -

If(Isnull(Flag), 'No',Flag) as Flag

OR

If you can creating this flag then add the else condition as 'No'

vamsee
Valued Contributor

Re: How to select entries that aren't valued in a list box?

Use Applymap() instead of Join

Flag_Map:

Mapping LOAD CoCd &'|'& DocumentNo as Key,

               Flag

FROM

(ooxml, embedded labels, table is Data);

Data:

LOAD

                CoCd,

               DocumentNo,

                Amount,

                Applymap('Flag_Map', CoCd &'|'& DocumentNo ,'NO') as Flag

FROM

(ooxml, embedded labels, table is QV);

hbleby96
New Contributor II

Re: How to select entries that aren't valued in a list box?

This works! Thank you so much!!