Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai_Mohan
Contributor III
Contributor III

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

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

Labels (2)
4 Replies
Kushal_Chawda

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

Sai_Mohan
Contributor III
Contributor III
Author

Hi @Kushal_Chawda ,

Thanks for Replying!

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

Sai_Mohan
Contributor III
Contributor III
Author

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