topic Text Comparison not working in QlikView

Text Comparison not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a simple yet not working expression that does not seem to change output no matter what here is the following example shown below.

Both are Excel tables from different Excel Files

Master_names
Bond,James
Smith,Will
Wahlberg,Mark

Check_List

Smith,Will

I want to output the Master_names not in the check_List table so I wrote the following expression to output a table object.

if(Master_names <> Check_List, Master_names) // this outputs the entire Master_names table

outputs this

OUTPUT
Bond,James
Smith,Will
Wahlberg,Mark

My question is what am I doing wrong I check for the string length and Trim functions to remove any white spaces or leading white space.

This is the desired output

Desired Output
Bond,James
Wahlberg,Mark

Re: Text Comparison not working

sunny_talwar — Tue, 08 May 2018 19:44:13 GMT

May be try this

Check_List:

LOAD Check_List

FROM ....;

Master_Names:

LOAD Master_Names

...

FROM ....

Where not Exists(Check_List, Master_Names);

Re: Text Comparison not working

vishsaggi — Tue, 08 May 2018 19:48:54 GMT

Try this may be:

Text2:

LOAD * INLINE [

Check_List

'Smith,Will'

];

Text1:

LOAD * INLINE [

Master_names

'Bond,James'

'Smith,Will'

'Wahlberg,Mark'

];

NoConcatenate

Final:

LOAD *

Resident Text1

WHERE NOT Exists(Check_List, Master_names);

Drop Table Text1;

Replace the inline loads with your Excel source.

Re: Text Comparison not working

Anonymous — Thu, 10 May 2018 02:28:00 GMT

Thank You for answering, but I need it to where the data is not "fixed" or known on any of the tables.

Re: Text Comparison not working

Anonymous — Thu, 10 May 2018 02:29:54 GMT

How would I do this within the expression editor ex. building a visual table within the app.

Thank You

Re: Text Comparison not working

sunny_talwar — Thu, 10 May 2018 14:21:55 GMT

May be using set analysis in your expression

{<Master_Names = e(Check_List)>}