topic Binary Load in QlikView

Binary Load

parvez933 — Thu, 06 Dec 2018 08:54:42 GMT

Hi Everyone!

I have a query that, we can be able to restrict the data on a binary load.

Ex:

A.qvw having the data

load * inline [

Year, Sales

2000, 123

2001, 234

2002, 345

2003, 456

2004, 567

2005, 678

2006, 789

2007, 891

2008, 112

2009, 121

2010, 145

];

If I am using the A.qvw into B.qvw (Binary <path> A.qvw) can I restrict the data so that can able to fetch the data only for the year 2006 or else 2006 or above?

Re: Binary Load

agigliotti — Thu, 06 Dec 2018 09:20:38 GMT

i guess you can't with only a binary load.

Re: Binary Load

Somasundaram — Thu, 06 Dec 2018 09:27:29 GMT

Hi,

Not able to restrict data while binary load. after binary load you can restrict using resident load.

Binary <path> a.qvw;

Load *

resident <tablename> where <field> ='2006';

Re: Binary Load

parvez933 — Thu, 06 Dec 2018 09:32:50 GMT

Hi Somasundaram,

Yes, after loading the data from binary, we can restrict the data in the chart or in the script.

Is there is any possibility to restrict from the binary load.

Re: Binary Load

juliensaintmaxent3113 — Thu, 06 Dec 2018 09:56:20 GMT

hello,

you have two choices:

load after the binary with where condition or in the app A make where condition

Bye

Re: Binary Load

parvez933 — Thu, 06 Dec 2018 10:02:09 GMT

Hey Jsaint,

Thank you for your response!