topic Re: Best approach to fetch data from source on Workday basis in QlikView

Best approach to fetch data from source on Workday basis

agni_gold — Fri, 16 Nov 2018 10:44:44 GMT

Hi Friends,

I have one question, like, i need to fetch data from some source on the workday basis, one way i know to create a separate qvw which will be a success on that workday and rest of the days, it will fail,

Is there any other approach we have, any connector or something to achieve this?

Re: Best approach to fetch data from source on Workday basis

Gysbert_Wassenaar — Fri, 16 Nov 2018 11:29:00 GMT

Put a check in the script:

If  WeekDay(Today()) >4 Then
    Exit Script;
EndIf

// if it's a work day then execution of the script continues below

Re: Best approach to fetch data from source on Workday basis

agni_gold — Fri, 16 Nov 2018 11:31:14 GMT

But in this case, other then workday, no data will be loaded in the dashboard , but i want to show the old data till next load is specific workday not came.

Re: Best approach to fetch data from source on Workday basis

Gysbert_Wassenaar — Fri, 16 Nov 2018 11:35:02 GMT

Ah, right. Ok, well one way is to have one app that creates the data model and stores all the tables as qvd's (and then drops them for this app) and then have another app that loads the qvd's and contains the charts and other visualisations. You'd put the check I posted above in the qvd generator. That way the front end app can always load the qvd's. The qvd's simply won't be updated in the weeked. No need for failing reloads that way.