Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
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
Highlighted
Specialist
Specialist

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

View solution in original post

3 Replies
Highlighted
Specialist II
Specialist II

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'

Highlighted
Specialist
Specialist

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

View solution in original post

Highlighted
Contributor II
Contributor II

This works! Thank you so much!!