topic Re: Exist functionality question in QlikView

Exist functionality question

raju_salmon — Sat, 23 Dec 2017 05:22:47 GMT

Hi,

I need to filter the data using exists. If i filter data

load

from table

where Year=2017;

It is considering as Non-Optimized load.

But i want to load QVD as optimized so i used below

load

from table

where Exists (Year, '2017');

But it is throwing an error.

The same syntax available in help. Not sure where its gone wrong.

Can anyone help me how can we filter data using exists function? to keep QVD as optimized?

Thanks,

Raju

Re: Exist functionality question

kaushiknsolanki — Sat, 23 Dec 2017 08:01:54 GMT

Try this.

Temp:

Load * inline [

Year

2017

];

load

from table

where Exists (Year);

Regards,

Kaushik Solanki

Re: Exist functionality question

Anil_Babu_Samineni — Sat, 23 Dec 2017 08:26:35 GMT

To which table you are going to Exists() ??

Re: Exist functionality question

raju_salmon — Sat, 23 Dec 2017 17:28:22 GMT

Hi Anil,

I have only table where i need to filter 2017 data with Optimized load.

In help, below information is available but it is not working as expected.

exists(Month, 'Jan') returns -1 (true) if the field value 'Jan' is found in the current content of the field Month.

Re: Exist functionality question

raju_salmon — Sat, 23 Dec 2017 17:34:17 GMT

Can anyone help why below on is not working?

load

Date,

Week,

Month,

Year

from Master_Calendar

where Exists (Year, '2017');

Re: Exist functionality question

marcus_sommer — Sat, 23 Dec 2017 17:39:02 GMT

Why not going with the suggestion from Kaushik? It will work!

To understand more how exists() could be use take a look on last link-block in this posting: Advanced topics for creating a qlik datamodel.

- Marcus

Re: Exist functionality question

Anil_Babu_Samineni — Sun, 24 Dec 2017 06:13:25 GMT

Exists works only fields not field values, So i would suggest to concatenate to dummy table which need like island table