topic Re: ytd - how can do it ? in QlikView

ytd - how can do it ?

Anonymous — Sun, 15 Jul 2012 11:48:37 GMT

hai

i have 3 feilds: 1 - year 2 - month 3 - sum kg

i want to calculate the ytd for the "sum kg".

i uesed :

SUM ({<year={'$(vMaxYear)'},month={'<=$(vmaxMonth)'},month=>}{$<_Flag={Inv,InvAdel}>}sum kg

)

but it's show me only the current month.

how can i do it?

thanks'

yarin.

SUM({<year={'$(vMaxYear)'},month={'<=$(vmaxMonth)'},year=>}{$<_Flag={Inv,InvAdel}>}sum kg

Jason_Michaelides — Sun, 15 Jul 2012 12:40:12 GMT

Try:

SUM ({<year={"$(Max(Year))"},month={"<=$(=Max(Month))"},_Flag={Inv,InvAdel}>}sum kg)

Hope this helps,

Jason

Anonymous — Sun, 15 Jul 2012 13:11:04 GMT

hay

thanks' but now it doesn't show anything.

do you have any idea?

yarin.

Jason_Michaelides — Sun, 15 Jul 2012 13:47:58 GMT

Is sum kg in square brackets, [sum kg].

jonathandienst — Sun, 15 Jul 2012 15:14:34 GMT

Yarin

Assuming everything else is correct, I suggest that you try this:

SUM ({<year={"$(=Max(Year))"},month={"<=$(=Max(Month))"},_Flag={'Inv','InvAdel'}>} [sum kg])

(Courtesy Jason, with some minor grammatical fixes)

Hope that helps

Jonathan

Jason_Michaelides — Sun, 15 Jul 2012 16:13:48 GMT

D'oh! Thanks Jonathan!

SunilChauhan — Sun, 15 Jul 2012 17:57:17 GMT

You can try below

SUM ({<year={"$(=Max(Year))"},month=P({<year={"$(=Max(Year))"}>}MOnth},_Flag={'Inv','InvAdel'}>} [sum kg])

hope this helps