topic Re: Need to get YTD in QlikView

Need to get YTD

bharatkishore — Wed, 14 Feb 2018 13:41:05 GMT

Hi All,

I have fields like Sales_Org ,Cat, Product Group and Calendar_Month

Now in calendar month i have 12 months

Now i have a field called consumption

For example say

Month Cons

201701 10

201702 20

201703 30 and so on

Now what i need to get is if i select 201701 i need to get 10 then if i select 201702 i need to get 10+20 =20 and if i select 201703

i need to get 10+30 =60.

Can you please help me how can i do it. is it is possible to do in back end.

please let me know if you need anything more. Attached app for more ref

Thanks,

Bharat

Re: Need to get YTD

sunny_talwar — Wed, 14 Feb 2018 13:43:15 GMT

You are looking to calculate rolling 12 months in the script? Is that what you are trying to do?

Re: Need to get YTD

Anil_Babu_Samineni — Wed, 14 Feb 2018 13:46:48 GMT

Month Cons

201701 10

201702 20

201703 30 and so on

Now what i need to get is if i select 201701 i need to get 10 then if i select 201702 i need to get 10+20 =20 and if i select 201703 i need to get 10+30 =60.

10+30 you are going to get or 10+20+30 ???