Best Approach for Qlikview Front end and backend

[#1]

Hi Techies,

My Qlikview application is getting bigger day by day as we load every month in QVD's.

I have data coming from Excels/Oracle/SQL and 6 months back the loading time was 30 min now it become 1hour 35 min.

Could you please suggest the best approach for loading data?

Will it be good if we separate backend(scripts) and front end Dashboard and load data through binary load?

[agomes1971]

Hi,

Best Approach to Load Data:

Incremental Loads but Total Loads When needed

https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/LoadData/UsingQVDFilesIncrementalLoad.h...

Types of loads in Qlikview

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

To the last question obviously Yes!

HTH

André Gomes