Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
How i can get Previous month from Current date as i need to generate QVD and use Month and Year as their filed using system date.
Thanks
Kushal Thakral
see the attched file
hope this helps
NEWTABLE:
Load *,
Month(AddMonths(Today(),-1)) as PreviousMonth,
Year(AddMonths(Today(),-1)) as PreviousYear
resident Orginal;
store NEWTABLE into path\NEWTABLE.QVD;
Thank You ALL
Regards
Kushal Thakral
Here's a calendar which allows you to determine previous periods depending on dates using flags
http://community.qlik.com/docs/DOC-6593
Regards
Richard
QlikCentral.Com