Limit Binary load or data that populates

[Anonymous]

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?

[lironbaram]

hi

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.

[Anonymous]

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.

[rwunderlich]

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