topic Re: archiving in QlikView

archiving

raadwiptec — Fri, 05 Feb 2016 08:05:33 GMT

Hi all,

I would want to have a chart archived to a QVD based on a specific dates automated?

Re: archiving

asgardd2 — Fri, 05 Feb 2016 08:25:46 GMT

Please explain more detail what you want. You can export table in qvd only then reload script is performing.

Re: archiving

tresB — Fri, 05 Feb 2016 08:34:51 GMT

Tabular charts can be stored into a qvd. And that would only store the data and not the chart layout.

....based on a specific dates automated?

Could you explain your requirement, may be with an example?

Re: archiving

raadwiptec — Fri, 05 Feb 2016 08:52:31 GMT

its a straight table.. Chart layout is not required. Using the archiving macro iam able to do it..

Dates means for example in the chart - we have column called end date.. so while archiving it to the Qvd ..I need to consider the end date should be the last date of the month. it should be a monthly archive basically

Re: archiving

tresB — Fri, 05 Feb 2016 08:56:42 GMT

So you want help in macro. Could you share the one you are working with?

Re: archiving

raadwiptec — Fri, 05 Feb 2016 10:11:51 GMT

no is their any other I can achieve this other than macro?

Re: archiving

tresB — Fri, 05 Feb 2016 10:36:39 GMT

I guess automation - would be a chanllenge (if not impossible wihout macro or something such external).

Re: archiving

raadwiptec — Fri, 05 Feb 2016 11:43:16 GMT

using the macro how to automate?

Re: archiving

jonathandienst — Fri, 05 Feb 2016 11:48:32 GMT

Can you do this during the reload? The script can calculate the dates required and output the qvd as part of the reload process.

Re: archiving

Anonymous — Fri, 05 Feb 2016 11:48:42 GMT

In the load script could you create resident table using a suitable where clause and columns and then store this to a qvd ?

Re: archiving

raadwiptec — Fri, 05 Feb 2016 11:53:40 GMT

bill that sounds good. but how can I see to that where the end date is the last date of the month

for ex

load....

resident....where only the last date = oit should be dynamic based on the month

Re: archiving

Anonymous — Fri, 05 Feb 2016 12:04:00 GMT

You could use the MonthEnd() function :

MonthEnd(Today())

Re: archiving

Fri, 05 Feb 2016 13:45:20 GMT

You can check against Now() or Tpday() function in the script.

IF Floor(Now()) = Floor(MonethEnd(Now())) THEN

AGGR_TABLE:

LOAD

FIELD1,

FIELD2,

FIELD3,

EXPRESSION1,

EXPRESSION2

RESIDENT FactTable

GROUP BY

FIELD1,

FIELD2,

FIELD3

;

STORE AGGR_TABLE into QVD_NAME.qvd (qvd) ;

ENDIF