topic Re: YTD in QlikView

YTD

stephenedberkg — Fri, 22 Jan 2016 11:18:24 GMT

I attach the sample app

YTD value are not coming correct?

Re: YTD

PradeepReddy — Fri, 22 Jan 2016 12:16:36 GMT

create a variable as vMaxMonth=Max(MonthID)

Use that variable in set analysis..

Re: YTD

stephenedberkg — Fri, 22 Jan 2016 13:10:38 GMT

Dear pradeept

i tried this but its not working

Re: YTD

sunny_talwar — Fri, 22 Jan 2016 13:18:08 GMT

What is the expected output you are hoping to see and in which object? Bar Chart or Text Box object?

Re: YTD

stephenedberkg — Fri, 22 Jan 2016 13:29:52 GMT

if i select Feb i want to see both jan and feb values in bar chart

Re: YTD

sunny_talwar — Fri, 22 Jan 2016 13:32:59 GMT

Try this expression:

=Sum({<Year={$(=Max(Year))}, Months, Year, Month, MonthID = {"<=$(=Max(MonthID))"}>}

Aggr(If(Only({1}MonthIDS) = Max(TOTAL <ID> {<Month>} MonthID) + Only(TOTAL <ID> {<Month>} [lock period]),

Sum({<Year={$(=Max(Year))}, Months, Year, Month, MonthID = {"<=$(=Max(MonthID))"}>}sales)), ID, MonthIDS))

Re: YTD

stephenedberkg — Fri, 22 Jan 2016 13:58:35 GMT

Dear Sunny,

thank you

this is working correct in sample app

but while i applied in my app its not working correctly

please find attachment

Re: YTD

sunny_talwar — Fri, 22 Jan 2016 14:17:27 GMT

Did it work?

Re: YTD

stephenedberkg — Fri, 22 Jan 2016 14:23:02 GMT

Dear sunindia

its working on that sample app only but its not working in my apps

i had post the app in previous command

Re: YTD

sunny_talwar — Fri, 22 Jan 2016 14:24:47 GMT

Will be checking it.

Re: YTD

sunny_talwar — Fri, 22 Jan 2016 15:55:44 GMT

Man your data model seems to be a different one. I will have need to look at this at a later time bro.

Re: YTD

stephenedberkg — Sat, 23 Jan 2016 12:56:52 GMT

Dear sunindia

i got the correct answer

thanks a lot dear sunindia