Re: Need to get YTD - Qlik Community

bharatkishore · ‎2018-02-14

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

sunny_talwar · ‎2018-02-14

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

Anil_Babu_Samineni · ‎2018-02-14

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 ???

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful