Store MTD data into QVD - Qlik Community

Anonymous · ‎2017-11-21

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 · ‎2017-11-21

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);

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

PrashantSangle · ‎2017-11-21

Hi,

If you always want MTD then

you can simply try like

Load * from tableName

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂