topic Re: Current YTD/Last Year YTD in QlikView

Current YTD/Last Year YTD

sat_tok52 — Wed, 15 Jun 2016 07:48:59 GMT

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

Re: Current YTD/Last Year YTD

MK_QSL — Wed, 15 Jun 2016 07:53:59 GMT

Provide some more information

Re: Current YTD/Last Year YTD

bindu_apte — Wed, 15 Jun 2016 07:54:44 GMT

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

Re: Current YTD/Last Year YTD

Anonymous — Wed, 15 Jun 2016 08:09:18 GMT

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