Current YTD/Last Year YTD

[sat_tok52]

Hi Guru's,

I have to calculate Current YTD /Last Year YTD  to till date it means

Current Year YTD(From Jan-01-2016 to Today) / Last Year YTD( Jan-01-2015 Last Year Same Day).I have used Some Qlikview Function it's Working but my chart is displaying total 12 month,I don't want like that .Below is my Expression

(Count({<Trade={'All'},Date={'>=$(=YearStart(Today()))<=$(=Today())'}>}Id)

/Count({<Trade={'All'},Date={'>=$(=YearStart(Today(),-1))<=$(=Today())'}>}Id)-1

Thanks,

Sateesh.T

[MK_QSL]

Provide some more information

[bindu_apte · Accepted solution]

Hi,

Hope this threads will help you out.

Current YTD vs Previous year YTD | Qlik Community

How to calculate volume and mix effect last year vs current YTD

[Anonymous]

Hi

Try this,

Current Year to Date: Date={'>=$(Date(YearStart(Today())))<=$(max(Date))'}.

Last year to Date :try this link to get last year same day

Last year sameday