How to use Excel file values in Not Match() in QlikSense

[Sai_Mohan]

Hi Team,

I have issue in using excel file field into not match func. I have excel file which has one field and two values in it.

Country

Japan

Malaysia

I need to exclude these two values in my report. So I have used

Below Load statement : 

where Not Match (Country , 'Japan', 'Malaysia')  ---- this works fine.

But I need to directly give that excel file column name in my load statement.

I have loaded data into data load editor.

Country:  // table name

Load

Country   // Field name

FROM $(Country_File)  //variable created
(OOXML, EMBEDDED LABELS, TABLE IS Sheet1)

I have used like this

where Not Match (Country_SQL , Country) // This Country_sql comes from main table where i need exclude these two values. // Country is Excel field 

But, country column is not found error iam getting 

Please help me ASAP.

Thanks in Advance

[Kushal_Chawda]

change where Not Match (Country_SQL , Country) to where Not exists (Country_SQL , Country)

[Sai_Mohan]

Hi @Kushal_Chawda ,

Thanks for Replying!

It Throws same error, Country field not found after giving not exists ().

[Sai_Mohan]

Hi @Kushal_Chawda ,

In General,

How to read field values from excel sheet? do we need to give function?

[Kushal_Chawda]

make sure that first parameter of exist is field name from first loaded table and second parameter should be field name of existing table where you are applying where clause.

Table1:

load *,

        Country_SQL

FROM table1;

table2:

load *,

         Country

FROM table2

where not exists(Country_SQL,Country);