Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Product Qty and Product Amount and field Link_Date.
I want to show in chart Sum(Qty) and Sum(Amount) with these Time Frame.
Suppose My Last date is 08-03-2016
1) Month To Date ( Data should be From 01-03-2016 to 08-03-2016)
2) Last Month To Date ( Data should be From 01-02-2016 to 08-02-2016)
3) Last Year Month To Date ( Data should be From 01-03-2015 to 08-03-2015)
4) Year To Date ( Data should be From 01-04-2015 to 08-03-2016)
5) Last Year To Date ( Data should be From 01-04-2014 to 08-03-2015)
Plz help me out to write the expression.
Thanks,
Lalit Kumar
Hope this helps you .
Vikas
Hi Vikas,
Thanks a lot, this is working for full month.
I need data of last month till date.
1) Month To Date ( Data should be From 01-03-2016 to 08-03-2016)
2) Last Month To Date ( Data should be From 01-02-2016 to 08-02-2016)
3) Last Year Month To Date ( Data should be From 01-03-2015 to 08-03-2015)
4) Year To Date ( Data should be From 01-04-2015 to 08-03-2016)
5) Last Year To Date ( Data should be From 01-04-2014 to 08-03-2015)
Sorry for misunderstood refer this https://community.qlik.com/message/328412#328412
and Re: YTD/YTD LY, QTD/QTD LY, MTD/MTD LY calculations
Thanks
Vikas
go through this https://community.qlik.com/docs/DOC-4313
vikas