topic Re: Binary qvw loading issues in QlikView

Binary qvw loading issues

remo0017 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

I have been having issues in field selection & applying filters [Where conditions] on the fields from the Binary qvw files.

I am trying to use the below snippet on top

Binary [..\..\XXXX.qvw];

But I would like to use something like this for my requirements by using above binary qvw file.

LOAD

b,..;

SQL SELECT

b,..

from table or Binary

where a='XXX' and b='YYYY';

Your help is much appreciated

Re: Binary qvw loading issues

rwunderlich — Sat, 10 Jun 2017 01:34:03 GMT

What does "from table or Binary" mean?

-Rob

Re: Binary qvw loading issues

Anil_Babu_Samineni — Sat, 10 Jun 2017 02:48:24 GMT

First of all, You can't use Binary script to load statement. So, here you are expecting on what? Would you elaborate more. I assume, You have binary data model and that you want to use one directory table to load statement special variation. Is this you are expecting. Please let us know which demonstrates the issue

Re: Binary qvw loading issues

fkeuroglian — Sat, 10 Jun 2017 03:08:17 GMT

I suppose that you want to exclude (using where condition) some information that you bring in your binary before.

If you want to do that, you can do:

Binary [..\..\XXXX.qvw];

Table1:

LOAD

b,..;

SQL SELECT

b,..

resident tableOriginal

where a='XXX' and b='YYYY';

Example: tableOriginal is a table that you have in your qvw binary, and Table1 will be the result of tableOriginal with the where conditions.

Hope help

Fernando

Re: Binary qvw loading issues

its_anandrjs — Sat, 10 Jun 2017 08:16:52 GMT

Hi,

Here you mean to say you want to create a table which is based on the Binary load or Model.

Regards,

Anand

Re: Binary qvw loading issues

Peter_Cammaert — Sun, 11 Jun 2017 18:23:11 GMT

A BINARY statement loads the entire data model from the specified document into RAM, including such - probably unwanted - stuff as Section Access etc. There's no escaping from that, it's how the BINARY statement works.

If you want to add or weed out tables/records/fields, you'll have to explicitly specify the changes after the BINARY statement using DROP or LOAD statements. IMHO Section Access information cannot be changed.

AFAIK the binary statement is conceived as some sort of DataMart fast loading technique.

See here for more info: Binary ‒ QlikView

Re: Binary qvw loading issues

kamal_sanguri — Mon, 12 Jun 2017 05:11:09 GMT

Use

Noconcatenate

Table1:

LOAD

resident <tablename>

where a='XXX' and b='YYYY';

Drop Table <tablename>;

Replace the <tablename> with the name of the table (which you can by looking at the data model by pressing Ctrl + T)

Please note: It is necessary to have Noconcatenate keyword before you load Table otherwise it will load the data and add it to original table. Also you can have Drop table statement, if you now don't need original table.

Re: Binary qvw loading issues

remo0017 — Mon, 12 Jun 2017 14:46:16 GMT

We have this situation for which we are using the Binary

LOAD A1,A2,A3;
SQL SELECT A1, A2,A3 from table1;

LOAD B1,B2;
SQL SELECT B1, B2 from table2;

AAA:
LOAD c1,c2,c3,c4;
select c1,c2,c3,c4 from table3;

outer join (aaa)

LOAD c,d;
SQL select c,d from table4;

table3 is joined with table1, table2 by c1,c2, but table1 & table2 doesn't have anything to join in common.

How do i apply where condition like this table1.A3 < table2.B2 and still get all the data from table3 & table4 ?

We thought to use this with some Binary and its so confusing

Re: Binary qvw loading issues

remo0017 — Wed, 14 Jun 2017 14:34:59 GMT

I have data from multiple tables which is being pushed into extract script which I am using as a Binary [Binary [YYYY.qvw] to load all the data into the report,

Now I have to create barchart & straight table by applying filters [where conditions] but I don't understand how I can use the fields from binary file to apply these filters.

Lets say I have A1 from table1 and B1 from table2 which are common and are part of this Binary file

Now how can I apply a condition like this

where table1.A1=table2.B2 ??