QTD & YTD

renuka_sasikumar · ‎2014-02-12

How to create QTD n YTD chart?

vikasmahajan · ‎2014-02-12

PFA sample Application hope this help you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

renuka_sasikumar · ‎2014-02-12

Hi,

I didn't get it how to do it in QV

M new to dis

vikasmahajan · ‎2014-02-12

Please share your excel or sample qvw to help you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

renuka_sasikumar · ‎2014-02-12

I have attached the qvw

Required QTD & YTD

MK_QSL · ‎2014-02-12

Dear Renuka,

Your data only showing for Year 2012 which is not helping us to create YTD, MTD or QTD.

Considering that you want your calculation for Current Year, use below formula.

FOR YTD

=SUM({<Date = {'<=$(=Date(Today()))'}, Year = {'$(=Year(Today()))'}>}[TOTAL INVOICE VALUE])

QlikView App Dev