Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Accumulate in dimensions

Hello experts!

I need you valuable help.

I have the above pivot in qlikview

MonthSales CYSales PYm2Visitors
13.774.659,1730.855.173,028.236,22677.175
Jan2.695.856,622.401.932,998.401,45127.612
feb1.740.020,232.012.334,008.354,1990.147
Mar1.762.776,731.636.124,548.231,6992.068
Apr2.890.977,003.245.520,458.021,08137.497
May2.532.552,552.456.297,858.091,10122.356
Jun2.152.476,042.359.258,678.351,44107.495
Jul0,002.569.794,96-0
Aug0,001.798.450,75-0
Sep0,002.118.124,61-0
Oct0,002.918.765,67-0
Nov0,003.463.481,42-0
Dec0,003.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:


MonthSales CYSales PYm2Visitors
13.774.659,1730.855.173,028.236,22677.175
Jan2.695.856,622.401.932,998.401,45127.612
feb1.740.020,232.012.334,008.354,1990.147
2mos4.435.876,85
Mar1.762.776,731.636.124,548.231,6992.068
3mos6.198.653,58
Apr2.890.977,003.245.520,458.021,08137.497
4mos9.089.630,58
May2.532.552,55

2.456.297,85

8.091,10122.356
5mos11.622.183,13
Jun2.152.476,042.359.258,678.351,44107.495
6mos13.774.659,17
Jul0,002.569.794,96-0
7mos13.774.659,17
Aug0,001.798.450,75-0
8mos13.774.659,17
Sep0,002.118.124,61-0
9mos13.774.659,17
Oct0,002.918.765,67-0
10mos13.774.659,17
Nov0,003.463.481,42-0
11mos13.774.659,17
Dec0,003.875.087,11-0
12mos13.774.659,17

I really appreciate any help you can provide!!

21 Replies
antoniotiman
Master III
Master III

Remove Month,

jmvilaplanap
Specialist
Specialist

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
Not applicable
Author

I removed month, which dimension should i pick instead?

because i need the month in my straight table

antoniotiman
Master III
Master III

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
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

you mean my idea?

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

Anonymous
Not applicable
Author

i tried your idea but it didn't work.

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

Anonymous
Not applicable
Author

I need only the month

Anonymous
Not applicable
Author

have a look at the attachment: