topic Re: MTD into YTD in QlikView

MTD into YTD

stephenedberkg — Thu, 21 Jan 2016 10:27:53 GMT

how to write below MTD expression in YTD?

=Sum({<Year={$(=Max(Year))},MonthID= {"<=$(=Max(MonthID))"},Month=,Year=>} Aggr(If(Only({1}MonthIDS) = Max(TOTAL <SKU> MonthID ) + Only(TOTAL <SKU> OrderLockPeriod) ,

Sum({<Year={$(=Max(Year))},MonthID= {"<=$(=Max(MonthID))"},Month=,Year=>}Arrivals)), SKU, MonthIDS ))

Re: MTD into YTD

sunny_talwar — Thu, 21 Jan 2016 10:29:40 GMT

Stefan where is a sample my friend? Without a sample you are just hoping someone will be able to help, please provide one with the desired solution so that we can help you in best possible way

Re: MTD into YTD

stephenedberkg — Thu, 21 Jan 2016 10:36:17 GMT

Dear sunindia

i attached the sample app.

i am using Personal edition so i can't access it. .

i changed the expression for my Requirement

=Sum({<Year={$(=Max(Year))},MonthID= {"<=$(=Max(MonthID))"},Month=,Year=>} Aggr(If(Only({1}MonthIDS) = Max(TOTAL <SKU> MonthID ) + Only(TOTAL <SKU> OrderLockPeriod) ,

Sum({<Year={$(=Max(Year))},MonthID= {"<=$(=Max(MonthID))"},Month=,Year=>}Arrivals)), SKU, MonthIDS ))

Re: MTD into YTD

Anonymous — Thu, 21 Jan 2016 10:37:07 GMT

may be like this?

=Sum({<Year={$(=Max(Year))},MonthID= {">=$(=Min(MonthID))"},Month=,Year=>} Aggr(If(Only({1}MonthIDS) = min(TOTAL <SKU> MonthID ) + Only(TOTAL <SKU> OrderLockPeriod) ,

Sum({<Year={$(=Max(Year))},MonthID= {">=$(=Min(MonthID))"},Month=,Year=>}Arrivals)), SKU, MonthIDS ))

Re: MTD into YTD

sunny_talwar — Thu, 21 Jan 2016 10:37:14 GMT

I don't see any attachment?

Re: MTD into YTD

stephenedberkg — Thu, 21 Jan 2016 10:38:25 GMT

Dear Sunny T

i attached the sample help me?

Re: MTD into YTD

stephenedberkg — Thu, 21 Jan 2016 10:42:25 GMT

Dear balrajahlawat

this expression also show the MTD Values only