topic Re: YTD , year over year in QlikView

YTD , year over year

Thu, 24 Jul 2014 07:06:11 GMT

PLZ find the attachment

HELPful for ytd ever

MK_QSL — Thu, 24 Jul 2014 08:22:20 GMT

=SUM({<Date = {">=$(=Date(MakeDate(max(Year),1,1),'DD MMM YYYY'))<=$(=Date(MakeDate(Max(Year),Month(Today()),Day(Today())),'DD MMM YYYY'))"}>}Value)

Thu, 24 Jul 2014 08:29:34 GMT

PFA the QWV.

Hope this is helpful.

Thanks

Sabal

Thu, 24 Jul 2014 08:38:58 GMT

Hi, thank u for post this is cytd

but privous ytd How?

Thu, 24 Jul 2014 08:49:17 GMT

Hi, saxena in 2nd chart , if i selected 2013 then it shows july 2012 to dec 2013 plz check

Thu, 24 Jul 2014 08:52:29 GMT

What is the requirement if you select 2013?

Thanks

Sabal

Thu, 24 Jul 2014 09:33:36 GMT

if i select 2013 or any year

jan 01 2013 to jul23 2013 (ytd)

jan 01 2012 to jul23 2012(pytd)

Thu, 24 Jul 2014 10:08:25 GMT

PFA the updated sheet.

Let me know if this is what you were looking for.

Thanks

Sabal

Thu, 24 Jul 2014 10:27:15 GMT

THANX A LOT

SAXENA

MY doubts clear on ytd