Discussion board where members can get started with QlikView.
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
Use Applymap() instead of Join
Mapping LOAD CoCd &'|'& DocumentNo as Key,
(ooxml, embedded labels, table is Data);
Applymap('Flag_Map', CoCd &'|'& DocumentNo ,'NO') as Flag
(ooxml, embedded labels, table is QV);
View solution in original post
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
If you can creating this flag then add the else condition as 'No'
This works! Thank you so much!!