topic Re: Store MTD data into QVD in QlikView

Store MTD data into QVD

Anonymous — Tue, 21 Nov 2017 09:30:14 GMT

Hi All,

I want to store max moth start to till date data in to QVD. Daily I’m getting one day data. How to do this in Qliksense script .

Thanks,

Krishna

Anil_Babu_Samineni — Tue, 21 Nov 2017 09:37:00 GMT

Perhaps this?

Let Variable = Max(Month);

And in script, You may try like below?

Table:

Load Date From Source Where Date >=MonthStart($(Variable)) and Date <= Today();

Store Table into [Path\FielName.qvd] (qvd);

PrashantSangle — Tue, 21 Nov 2017 09:45:15 GMT

Hi,

If you always want MTD then

you can simply try like

Load * from tableName

where Date(dateField,'YYYYMM')=Date(Today(),'YYYYMM')

Regards,