Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

One data load into dashboard with Binary link

Hi Experts,

I have a dashboard that needs only day data, i.e. yesterday.

This dashboard and other dashboards are built using a QVW (in our case we call it as Data Model QVW).

Using the binary load, how can I limit the data into the dashboard for only one day?

I cannot limit the data into Data Model QVW as it is used in other dashboards that need who set of data.

Any suggestions or advises is highly helpful.

Thanks in advance

7 Replies
Anil_Babu_Samineni

I don't think so whether it can club and we have the option with Binary and Where condition at a time. Can you share more information such

1) Why this need from new qvw by helping of Binary

2) Is that customer asking you, If so what case they need to look

3) My assumption, Try this before load that qvw only using qvd and help of NoConcatenate.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
hector_munoz
Specialist
Specialist

Hi Shyam,

You can not control binary load: you inherit tables, their data and their relations and after that you add new tables to the model or delete those that you donot need. So what you could do is creating a NO CONCATENATE fact table from the initial one with only the data you need (WHERE Date = (Today() - 1) and later dropping the original.

Hope it serves...

Regards,
H

shyamcharan
Creator III
Creator III
Author

Hi Anil,

Thanks for your response.

It is how I designed the solution.

I wanted to have one central QVW with all the tables and data in it and build the dashboards using this main QVW(Datamodel or called Universe in terms of BUsiness objects)

This will have less maintenance and easy to use.

Yes, I will try NoConcatenate option. Thanks heaps.

shyamcharan
Creator III
Creator III
Author

Thanks hector. Will try the NoConcatenate option

Thanks heaps.

Anil_Babu_Samineni

I may not understand this part. Yes, You have existing file and then you have one new qvw with the load of Existing qvw by help of Binary. And then finally you need one more qvw which instance with Where condition of one day. You meant to say

I am afraid, If there is option using binary load with where condition. May be they will help us

stevedarkmrkachhiaimpstalwar1

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinodkumark
Contributor
Contributor

Hi Shyam,

I don't think you can limit the data using the binary load. But additional to your binary load statement you can add resident load statements.

For example,

In binary load, if you are loading data from your 'Data Model QVW' then the tables(in your Data Model QVW) are created by default in your new QVW/Dashboard once the reload done. So further, you can filter on the table that is created using Resident load statement with the filter on date column (Today()-1).

To view the tables created use CTRL-T statement.

stevedark
MVP
MVP

Hi Shyam,

The binary load always takes the entire data model across.  This is one of the reasons why I do not use it.

You can drop tables from the new model once loaded, but it is far better not to bring in data you don't need.

Another method is to store all to QVD and then load all from QVD.

This code will do the store part;

//  Code to store all tables in a model to QVD

let iTabs = NoOfTables() -1;

for iTab = 0 to iTabs

       let vTab = TableName(iTab);

       STORE [$(vTab)] INTO [.\QVDOutput\$(vTab).qvd] (qvd);

next

for iTab = 0 to iTabs

       let vTab = TableName(0);

       DROP TABLE [$(vTab)];

next

And this code will then load all QVDs from the same folder:

// Code to load all QVDs from a table to the model

for each vQVD in FileList('.\QVDOutput\*.qvd')

       LOAD

              *

       FROM [$(vQVD)] (qvd);

next

On the load into the new app(s) you can then chose to pick which QVDs to load from, or add WHERE statements, rather than doing a loop and loading all data - should you require.

Hope that helps.

Steve