topic Re: Limit Binary load or data that populates in QlikView

Limit Binary load or data that populates

Anonymous — Sat, 11 Mar 2017 20:40:39 GMT

From what I have read, there is no way to really limit data from a binary load. I do not want to have to create a new data model as the one we have is pretty large and contains everything we need for most of our reports. We need to create a copy of a dashboard for a specific client and I only want that client's information and statistics to show. I want to be able to load a dashboard we have from the binary load, but I only want the entire dashboard to load one Client's information.

Is there a way to limit the entire QV document/Dashboard by a specific Client ID?

Re: Limit Binary load or data that populates

lironbaram — Sun, 12 Mar 2017 11:31:55 GMT

there are several options :

if you have Qlikview publisher you can create a reduce task :

http://help.qlik.com/en-

US/qlikview/12.1/Subsystems/QMC/Content/QMC_Documents_SourceDocuments_Wizard_Reduce.htm

if you use qlikview and nprinting 16.X you can create a reduce task there

or you can manually open the model select the client and select reduce data from the File menu

and select keep possible values.

Re: Limit Binary load or data that populates

Anonymous — Sun, 12 Mar 2017 14:26:44 GMT

Thank you, my best option was to make a copy of the data model and use the reduce data from the file menu. This will allow us to keep the original data model intact and allow the dashboard development.

Re: Limit Binary load or data that populates

rwunderlich — Sun, 12 Mar 2017 16:17:35 GMT

You can manipulate the data model after the binary load to reduce or add data. For example:

BINARY Sales.qvw;

INNER JOIN(Orders) LOAD * INLINE [

CustomerId

1234

];

INNER JOIN(Customers) LOAD CustomerId RESIDENT Orders;

INNER JOIN(Products) LOAD ProductId RESIDENT Orders;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com