topic Re: binary load in QlikView

binary load

manoranjan_d — Tue, 25 Apr 2017 10:58:46 GMT

In Binary load user can use Where Clause, Group By clause and other SQL-like syntax?

Re: binary load

avinashelite — Tue, 25 Apr 2017 11:01:34 GMT

Directly no where clause , Group By clause and other SQL-like syntax

but you could do a resident load the then use the where clause , Group By clause etc

Re: binary load

manoranjan_d — Tue, 25 Apr 2017 11:04:29 GMT

so u r saying

it is applicable to resident load,

it is not applicable to binary load

am i correct

Re: binary load

awhitfield — Tue, 25 Apr 2017 11:15:04 GMT

Binary

The binary statement is used for loading the data from another QlikView document, including section access data. It does not load the layout information or variables.

Only one binary statement is allowed in the script and it must be the first statement of the script, even before the SET statements usually located at the beginning of the script.

Syntax:

binary [path] filename

HTH Andy

Re: binary load

avinashelite — Tue, 25 Apr 2017 11:19:25 GMT

yes, your rite

Re: binary load

manoranjan_d — Tue, 25 Apr 2017 11:31:54 GMT

hi whitfiled,

so binary load will load the script portion of the document?

Re: binary load

avinashelite — Tue, 25 Apr 2017 11:38:37 GMT

It loads all the script tables and model of the binary load file except the UI objects and Variables

Re: binary load

awhitfield — Tue, 25 Apr 2017 11:41:20 GMT

Yep!

Re: binary load

avinashelite — Tue, 25 Apr 2017 12:00:30 GMT

If you have got the answers mark the correct and helpful answers and close this thread