Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
It would be grateful for me if someone help me in the query of Qlik Sense
I have created the multiple qvd's from different sources. When I accumulate all the qvd's in the single app; the size of the app increases to 5G.
I have made certain sheets based on the qvd's.
The issue I am facing is that when I click on the sheets it take lots of time to show the visualization. Its shows loading and loading. In the same manner when I used filter on it it takes the shows the bubble for 10 to 15 minutes..
Thus the performance level is very very poor.
Can someone please suggest how can I used my qvd in a better way so that the performance level becomes better.
I need to use all those qvd in a single app... Can we save the qvd in some other extension or some thing else??
Please suggest
Regards
DC
You need to check your model.
Sounds like you have a synthetics keys or issue with your table's joins (if you are doing it).
And if everything is ok there, I would suggest to re-design your UI.
You probably do not need to show all records at once (as I am assuming you are doing now).
It's recommended to use some aggregation on first page of the app and drill-down (based on selections) UI on the following pages.
Regards,
Vlad
Appears that you have too many synthetic keys or bad joins done on date dimensions.
Thanks Sir!!
In my data model there are no synthetic keys..
The qvd store more than 100 million records which might hangs all the things
Just to add on this my Qlik Sense tool works on Client machine
I read about the Buffer load which increases the performance level.
Can we do this by Buffer load and if yes how?
Please suggest
Thanks!!
Sounds like you need to review/update your UI/Script options...
Do you REALLY need 100,000,000 records to be displayed at once??
I am assuming you can do some aggregation on the main app's page (KPI, Totals, etc) and drill down to the detail reports on the following pages (after the selection(s) has been made).
Buffer load (I am actually not sure if it's supported in QS yet) will not help you much, IMHO.
It will just load a portion of your data and will require additional time/system resources to load the rest of it.
Regards,
Vlad
if you can share us more detail about your requirement. As a user we all know we cannot analyze 100 milion records on a single chart. My suggestion for you is follow this below best practices:
1. When extracting the data from database and creating a QVD:
Data model:
Front End:
Let me know if that helps you