Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
zarmoton
Creator
Creator

Publisher : 2 documents name in ACCESSPOINT with the same QVW (long or short term data), but easy maintenance...

Hello
I have a huge model (of 2.2 Go), that i'm refreshing every hour. (with QMC) , call : MYAPP
But Model is too heavy.

To update is qvw, it's in 2 steps. i have another task, call PREP_TASK, schedule every hours, and then once PREP_TASK is updated, MYAPP is starting to reload (task dependanices), and then publish to my ACCESSPOINT


So, I would like to introduce in the script, that if TIME is between 5 to 6 am, i load all data, and to publish (with publisher) to my server ACCESSPOINT, with the name "MYAPP_FULL"
And all other updates (ie TIME before 5 am or after 6 am) to have a WHERE clause in my script in order to keep only 1 month of history for example, and then to publish (with publisher) to my server ACCESSPOINT, with the name "MYAPP_LIGHT"

Like that, if users want only latest data, they open "MYAPP_LIGHT", but if they want to do long term analysis then open "MYAPP_FULL". And we maintain only 1 version of the QVW.


Any help more than welcome


Regards,

Thk yu

0 Replies