topic Re: Reload different sqls in same qvw at different times in QlikView

Reload different sqls in same qvw at different times

anuradhaa — Fri, 04 Dec 2015 05:18:23 GMT

Hi,

My qvw i have several sqls and i want to schedule the reloads of those sqls in different time frames,

say SQL1 @ 07:00 am every day

SQL 2 @ 2.30 pm every day etc

is this possible

Re: Reload different sqls in same qvw at different times

tresB — Fri, 04 Dec 2015 05:29:13 GMT

May be like:

If hour(Now())=7 Then

          SQL query1

     Else If hour(now())=14 and minute(now())=30 Then

          SQL query2

     End if

End if

And the reload for the qvw has to be scheduled accordingly (at least twice at those times)

Re: Reload different sqls in same qvw at different times

Fri, 04 Dec 2015 05:31:33 GMT

Hi,

You want this to be implemented through QMC?

If so we can schedule two different tasks for the same QVW to run at different times with a if condition included in the script. Like SQL1 in one if condition which will be true for one reload time and false for other reload time.

Re: Reload different sqls in same qvw at different times

anuradhaa — Fri, 04 Dec 2015 06:43:45 GMT

Yes, it works . But then the data already loaded in previous reload get disapired.

I want to keep the data of SQL2 when SQL1 run and vis versa.

Re: Reload different sqls in same qvw at different times

Fri, 04 Dec 2015 06:47:57 GMT

You can store the data in QVD's and use them

Re: Reload different sqls in same qvw at different times

tresB — Fri, 04 Dec 2015 07:06:04 GMT

Try like:

If hour(Now())=7 Then

        Table1:

          SQL query1

        Store Table1 into table1.qvd (qvd);

     Load * from table2.qvd(qvd);

    Else If hour(now())=14 and minute(now())=30 Then

          Table2:

          SQL query2

        Store Table2 into table2.qvd (qvd);

     Load * from table1.qvd(qvd);

    End if

End if

To get this working, you have to run the store once to get qvd created.

Or, you can try with Partial reload