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

[Anonymous]

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

[neelamsaroha157]

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 · Accepted solution]

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);

[Anonymous]

This works! Thank you so much!!