Separate reload frequencies between multiple tables

Wed, 12 Mar 2014 03:40:53 GMT

Hi All,

I need to build a movement report which involves movement of data from the same table.

The keys used are going to be company, branch, clientnumber and claimnumber. I'll be comparing changes in estimates.

I want to take a snapshot of this table at the start of each month and store as a separate table that doesn't get altered throughout.

This snapshot table is then referenced back to the original table each day throughout the month and if the difference in estimates between the daily reloaded table and the monthly snapshot table aren't zero, then I can put an indicator against the original table to state there has been some movement.

Is there any way to take snapshot reloads of data within the Qlikview reload script and if so how can this be done?

Let me know if further information is needed.

Regards,

Nathan

Re: Separate reload frequencies between multiple tables

vikasmahajan — Wed, 12 Mar 2014 07:15:19 GMT

Go through this discussion QV Management Console, reload document hourly M-F, 7am-7pm?

Vikas

topic Re: Separate reload frequencies between multiple tables in QlikView

Separate reload frequencies between multiple tables

Re: Separate reload frequencies between multiple tables