topic Re: Need help in simple qlikview script in QlikView

Need help in simple qlikview script

Wed, 26 Mar 2014 00:59:52 GMT

The script -

TABLE1: LOAD * INLINE [ F1, F2 1, a 2, b 3, c ]; LOAD * INLINE [ F1, F2 4, d 4, e ] WHERE NOT Exists(F1) ;

I know SQL and the syntax for Qlikview's "where" confuses me. In "WHERE NOT Exists(F1)" F1 belongs to which table ?

Re: Need help in simple qlikview script

srchilukoori — Wed, 26 Mar 2014 01:04:15 GMT

In the above script, F1 refers to both the first and the second tables.

Re: Need help in simple qlikview script

Wed, 26 Mar 2014 01:05:07 GMT

Actually the not exists in the second load statement checks if the value of F1 being loaded is already present in the data model, in this case Table1. Since 4 is not already present, both the rows will be added.

To be more clear it is like this.

where not exists ( F1, F1)

1st argument is the already loaded field

second argument is the field being loaded.

In case the field name is different we can use as follows:

where not exists ( F1, Field1). Since in your case the field name is the same the second argument can be skipped.

Thanks,

Ram

Re: Need help in simple qlikview script

Wed, 26 Mar 2014 01:08:43 GMT

Attaching the help screen shot.

Re: Need help in simple qlikview script

Wed, 26 Mar 2014 01:14:30 GMT

thanks. Where can i see rest of the documentation in screenshot, ie API ?

Re: Need help in simple qlikview script

Wed, 26 Mar 2014 01:15:58 GMT

goto your qlikview desktop, press F1. type exists. You will get the documentation.

Thanks,

Ram

Re: Need help in simple qlikview script

srchilukoori — Wed, 26 Mar 2014 01:16:25 GMT

Check the Help documentation.

Re: Need help in simple qlikview script

Wed, 26 Mar 2014 01:17:14 GMT

" Since 4 is not already present, both the rows will be added." That is incorrect. Only one row will be added. More on that later.

Re: Need help in simple qlikview script

Wed, 26 Mar 2014 01:20:08 GMT

you are correct. I didn't notice. For both to be added, we need the condition slightly modified.

where not exists(F1) or not exists(F2).

Reason being we are checking for not exists(F1) and that works iteratively. We read the value of 4 for F1 and when we read the next row, since 4 is already available it didn't read it. Basically we can tweak this based on our needs.

Thanks,

Ram

Re: Need help in simple qlikview script

Wed, 26 Mar 2014 01:31:56 GMT

here is the link - Understanding EXISTS() function - Qlikview vs SQL/RDBMS

Re: Need help in simple qlikview script

Wed, 26 Mar 2014 01:35:30 GMT

Is there also a web docs for this, like API ? Anyway, this is how I got there -

Help > Contents or WebView Help > Index tab > Enter search word.