Accumulate in dimensions

[Anonymous]

Hello experts!

I need you valuable help.

I have the above pivot in qlikview

Month	Sales CY	Sales PY	m2	Visitors
	13.774.659,17	30.855.173,02	8.236,22	677.175
Jan	2.695.856,62	2.401.932,99	8.401,45	127.612
feb	1.740.020,23	2.012.334,00	8.354,19	90.147
Mar	1.762.776,73	1.636.124,54	8.231,69	92.068
Apr	2.890.977,00	3.245.520,45	8.021,08	137.497
May	2.532.552,55	2.456.297,85	8.091,10	122.356
Jun	2.152.476,04	2.359.258,67	8.351,44	107.495
Jul	0,00	2.569.794,96	-	0
Aug	0,00	1.798.450,75	-	0
Sep	0,00	2.118.124,61	-	0
Oct	0,00	2.918.765,67	-	0
Nov	0,00	3.463.481,42	-	0
Dec	0,00	3.875.087,11	-	0

I want to add rows in dimensions field,

I have  to show the data in a table as cumulative sum of Month

I want the data to be displayed like this:

Month	Sales CY	Sales PY	m2	Visitors
	13.774.659,17	30.855.173,02	8.236,22	677.175
Jan	2.695.856,62	2.401.932,99	8.401,45	127.612
feb	1.740.020,23	2.012.334,00	8.354,19	90.147
2mos	4.435.876,85
Mar	1.762.776,73	1.636.124,54	8.231,69	92.068
3mos	6.198.653,58
Apr	2.890.977,00	3.245.520,45	8.021,08	137.497
4mos	9.089.630,58
May	2.532.552,55	2.456.297,85	8.091,10	122.356
5mos	11.622.183,13
Jun	2.152.476,04	2.359.258,67	8.351,44	107.495
6mos	13.774.659,17
Jul	0,00	2.569.794,96	-	0
7mos	13.774.659,17
Aug	0,00	1.798.450,75	-	0
8mos	13.774.659,17
Sep	0,00	2.118.124,61	-	0
9mos	13.774.659,17
Oct	0,00	2.918.765,67	-	0
10mos	13.774.659,17
Nov	0,00	3.463.481,42	-	0
11mos	13.774.659,17
Dec	0,00	3.875.087,11	-	0
12mos	13.774.659,17

I really appreciate any help you can provide!!

[antoniotiman]

Remove Month,

[jmvilaplanap]

Just one idea, replace the last two lines (if (year='2017' .... for the following

if (Year = year(today()), 1, 0)     AS CY,

if (Year = year(today()) - 1, 1, 0)     AS PY

Then will be useful forever,

regards

[Anonymous]

I removed month, which dimension should i pick instead?

because i need the month in my straight table

[antoniotiman]

In script,if Your Month Field is DateField

Then   -> Month,

If Not then   -> Month(Date#(Month,'MMM') ) as Month,  or     Month(Date) as Month

You need Month Field as Dual Field (Text,Num)

[Anonymous]

i am attaching the qvw and the excel file

Can you please help me with the script because i cant make it work.

Thank you

[Anonymous]

i am attaching the qvw and the excel file

Can you please help me with the script because i cant make it work.

Thank you

[Anonymous]

you mean my idea?

btw do you really need month as dimension or wouldn't year-month be better?!?

[Anonymous]

i tried your idea but it didn't work.

I attached the qvw can you apply it in my actual data???

[Anonymous]

I need only the month

[Anonymous · Accepted solution]

have a look at the attachment: