Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

field not found in statement where not exists

Hello,

I have a problem...

I have two tables :

first named tmp :

tmp:

load *;

SELECT ,

  Field1

FROM table1

[Doc]:

LOAD

  

Field1

  resident tmp;

  drop table tmp;

the second tmp_targa:

tmp_targa:

LOAD chart

;

SELECT CHART

FROM Table2

i would like to use Where not Exists between the two table like :

final:

load*,

Where not Exists(CHART);

But I have a problem that the field chart is not found

what is the problem ?

8 Replies

Re: field not found in statement where not exists

What is the resident table here? Have you shared just the bits and pieces of the script? I would suggest sharing the complete script to help you better here...

zied_ahmed1
Contributor III

Re: field not found in statement where not exists

Yes this is a little of the script,

i removed other fields because we need to concentrate into Field1 and CHART because i need to display data of Field1 without the data similar in the second table for chart

Re: field not found in statement where not exists

Do remember field names are case sensitive in Qlik.

zied_ahmed1
Contributor III

Re: field not found in statement where not exists

yes i know i have only one field in the second table and i know that i need to respect case sensitive

Re: field not found in statement where not exists

You need to provide the full script otherwise I can only guess.

vinieme12
Esteemed Contributor II

Re: field not found in statement where not exists

Please post the entire script

zied_ahmed1
Contributor III

Re: field not found in statement where not exists

the problem is here ->

final:

load*,

Where not Exists(CHART);

load* is for the first table so it's normal to tell me that the field CHART is not found,what can I do guys ?

zied_ahmed1
Contributor III

Re: field not found in statement where not exists

Problem resolved, i need in the where not exist add the original name of Field name :

Where not Exists(CHART,Field1);

Community Browser