YTD & MTD

[lionking15]

HI,

In my table i am having date,fiscal month,fiscal year field for this i want to write YTD & MTD . How to do it??

Thanks!!!!!

[Anil_Babu_Samineni]

Have you tried anything. If yes, please post those Two set operator's

[#3]

This may helps you

YTQ, QTD, MTD and WTD

[arulsettu]

follow this

https://community.qlik.com/docs/DOC-6163

[bindu_apte]

Hi,

Hope this qvw will help you.

[lionking15]

Hi,

Suppose i select '21/02/2016' then YTD should show year between '01/04/2015' to 21/02/2016 as per fiscal year

[arulsettu]

can you post your qvw

[lionking15]

For YTD i have written

=sum({<Date={'>$(=monthstart(min(Date)) )<=$(=max(Date))'}>}[Sales Amount]) is it correct???