Huge data in qvd files

[Anonymous]

We have huge data(more than 2 GB) in 3/4 qvd files.

Qlikview dashboard is built (with inline script using) this qvd files.The dash board has 4-5 list box and 2 pivots.

Since the qvd are huge the qlikview dashboard has also became huge.

Now if we want to make any changes (in script or to add additional list box) it takes long time to open, some time it crashes.

Also, since the dashboard is huge user facing issues to use the dashboard.

Is there any way we can open the dashboard easily for editing.

Also, is there any way we can solve the problem of the user to access the dashboard.

What are the best practices for such scenarios

[shiveshsingh]

You can use reduction of application based on user( User Names or territory)

[Anonymous]

We cannot use the reduction

[shiveshsingh]

But you can remove the loaded data(keep possible values), do the changes and reload again.

[Anonymous]

Hi Shivesh,

After keeping the required columns our QVD files is more than 2 GB.

[vishsaggi]

Did you check your RAM how much it is when you open this dashboard. ?

Does your inline scripts has any transformations happening while loading your QVD files.

What happens when you just load these QVD files without any conditions in the script?

[Anonymous]

When I open this dash board maximum RAM of machine is used.

The dash board has 4-5 list box and 2 pivots.

And now I want to make some changes in this dashboard along with the optimization (minimize the size of .qvw file) so that next time any changes needs to be done then it can be made easily.

[Anonymous]

Can any one suggest on my query/issue

[ziadm]

2GB is such a big dashboard and wonder what would be the size in a year time .. you have to optimize the dashboard and follow best practice of QVW development

Performance and Optimization Best Practices in QlikView & Qlik Sense

[krishna20]

Hi Amar,

As i understood. your qvw application size is huge and it requires more RAM than which you are using now.

Please find the attached .xls and calculate how much RAM size could be required to your .Qvw file  and Change your system configuration accordingly .

RAM Calculation in QV Scalability

Thanks

Krishna