topic YTD Help??? in QlikView

YTD Help???

amit_saini — Tue, 03 Mar 2015 11:10:02 GMT

Hi Folks ,

I'm having expression as below:

if(sum([Act Planned Production Hours]) = 0, avg([Act OEE]),
sum([Act OEE]*[Act Planned Production Hours])/sum([Act Planned Production Hours]))

Need to calculate YTD from this . Any suggestions???

Thanks,

Re: YTD Help???

MK_QSL — Tue, 03 Mar 2015 11:13:18 GMT

YTD can be calcualated as below

SUM({<Year = , Month = , Date = {'>=$(=YearStart(Today()))<=$(=Today())'}>}MeasureField)

Re: YTD Help???

amit_saini — Tue, 03 Mar 2015 11:29:55 GMT

Hi Manish,

Thanks brother I already tried something similar and your suggestions also but getting blank values.

Thanks,

Re: YTD Help???

MK_QSL — Tue, 03 Mar 2015 11:34:19 GMT

Provide sample data please...

Re: YTD Help???

Tue, 03 Mar 2015 11:34:59 GMT

Hi,

Create a varible vCurrDate=today()-1

YTD

sum({<Months=, FiscalYear={$(=max(FiscalYear))},TRANDATE={"<=$(vCurrDate)"}>} [Act OEE]*[Act Planned Production Hours])

Regards

Vimlesh

Re: YTD Help???

timanshu — Tue, 03 Mar 2015 11:45:48 GMT

if(sum({<Year = , Month = , Date = {'>=$(=YearStart(Today()))<=$(=Today())'}>}[Act Planned Production Hours])=0,

avg({<Year = , Month = , Date = {'>=$(=YearStart(Today()))<=$(=Today())'}>}[Act OEE]),
sum({<Year = , Month = , Date = {'>=$(=YearStart(Today()))<=$(=Today())'}>}[Act OEE]*[Act Planned Production Hours])/sum({<Year = , Month = , Date = {'>=$(=YearStart(Today()))<=$(=Today())'}>}[Act Planned Production Hours]))

Re: YTD Help???

amit_saini — Tue, 03 Mar 2015 12:01:01 GMT

See attachment.

Thanks,
AS

Re: YTD Help???

amit_saini — Tue, 03 Mar 2015 12:08:14 GMT

Hi Manish,

See the attachment:

Need to calculate Act 2015 YTD

Thanks,

Re: YTD Help???

timanshu — Wed, 04 Mar 2015 05:13:53 GMT

Hi Amit,

Access is denied to document you attached.

It's showing error: Access denied to this qlikview document.

Re: YTD Help???

amit_saini — Wed, 04 Mar 2015 05:16:47 GMT

Hi Timanshu,

I got the solution for this:

if(sum({<Date={">=$(=YearStart(Date))<=$(=Max(Date))"},Year={2015},POPER_NEW=,Date=>}[Act Planned Production Hours]) = 0, avg({<Date={">=$(=YearStart(Date))<=$(=Max(Date))"},Year={2015},POPER_NEW=,Date=>}[Act OEE]),

sum({<Date={">=$(=YearStart(Date))<=$(=Max(Date))"},Year={2015},POPER_NEW=,Date=>}[Act OEE]*[Act Planned Production Hours])/sum({<Date={">=$(=YearStart(Date))<=$(=Max(Date))"},Year={2015},POPER_NEW=,Date=>}[Act Planned Production Hours]))

Thanks,