YTD Calculation by column wise!!

[srini]

Hi Friends,

I am struggling to calculate the YTD for the below data in qlik Sense. In Excle simply they used SUMIF to calculate the YTD.

But when I try to get the same in qlik sense I am not able to get... I am struggling... I have mentioned the result YTD also in the below table. Can some one help it would be really helpful. 

I have tried with earlier posts in the community but most of them are for row wise... and not useful for my case. 

My mind is not working with some extend 😞

Country	M01 Units	M02 Units	M03 Units	M04 Units	M05 Units	M06 Units	M07 Units	M08 Units	M09 Units	M10 Units	M11 Units	M12 Units	YTD
XYZ	0	0	0.52903	0	0	0	0	0	0	0	0	0		0.52903
ABC	1	0	0	0	0	0	0	0	0	0	0	0		1
def	0	-1	0	0	0	0	0	0	0	0	0	0		-1
jkl	0.375	0	0	0	0	0	0	0	0	0	0	0		0.375
mnop	0.375	0	0	0	0	0	0	0	0	0	0	0		0.375
sdfg	0.375	0	0	0	0	0	0	0	0	0	0	0		0.375
erty	0.375	0	0	0	0	0	0	0	0	0	0	0		0.375
mnhu	0	0.255918	0.028435	0	0	0	0	0	0	0	0	0		0.284353
hytr	0	0	0.568707	0	0	0	0	0	0	0	0	0		0.568707

Thanks in advance!

[sunny_talwar]

---

@srini wrote:
Hi Sunny, I hope it is there in the attachment with previous posts.

---

I am not sure which of the many posts you have contains the information. I want to help, but I am not sure what exactly you mean and unless I understand what you mean, I won't really be able to offer much help.

[srini]

Let me put it simple, how could I have this result as new field in script: Sum({} Units) I need this to be a new field. The above I will use in the attached data then I need to use the result as a new field for another table. 

Thanks!

[srini]

when I use the same logic and script with one of my other report, I am getting different out put. code: Test1: Load "Cycle Year", "Cyclename", // "Governance Group", // "Product Line", // "GPDM Portfolio", // "GPDM Programme", // "POB ID", // "POB Name", // "BP Priority", "BP ID (for filtering)", // "BP Name", Month(Date#(Num(TextBetween([Month],'M',' Uni')),'MM')) as [Month], Num(Month(Date#(Num(TextBetween([Month],'M',' Uni')),'MM'))) as [MonthNum], Units out put:

[sunny_talwar]

Please create a new thread for a new requirement

[srini]

done Sunny! expecting your advise