Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
Hi,
If you always want MTD then
you can simply try like
Load * from tableName
where Date(dateField,'YYYYMM')=Date(Today(),'YYYYMM')
Regards,