topic Re: New Column to Running Value in QlikView

New Column to Running Value

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All, I have three columns in my data . Month , C and O .

I want to diplay this information in a table .My requirement is like

I have to show the data from the month of May where C=0 and O is also zero and there should be one more column of

Running to be shown in the table which should calculute the accumulation from previous months (Jan to APR) and carry

forward from MaY , How can i achieve this . I am attaching the QVW file for refrence and the out put should look like below screenshot

Basically it is accumulate calculation

Thanks in advance

Re: New Column to Running Value

StarinieriG — Wed, 09 Oct 2019 07:17:41 GMT

Hi,

try to see file attached

Re: New Column to Running Value

smilingjohn — Wed, 09 Oct 2019 07:29:02 GMT

Thanks for the reply .

But this is not as per my requirement . I wanted to ddiplay a chart which has Month, C , O and a new field called Runing .

and this should start from the MOnth of May . and the Running Field should carry the calculations from previous monhts and start from month May ( Output of Runnig should be added to C abd the total should be subtracted from O and so on )

Thanks

Re: New Column to Running Value

smilingjohn — Wed, 09 Oct 2019 09:27:50 GMT

Any Help ?

Re: New Column to Running Value

Frank_Hartmann — Wed, 09 Oct 2019 10:50:49 GMT

Maybe like attached.

hope this helps

Re: New Column to Running Value

smilingjohn — Wed, 09 Oct 2019 11:06:30 GMT

Thanks for the reply Frank_Hartmann

I dont know how you are getting this .

My formula shoulb be like C-O= Running for the next month (row ) Running +C - O .

So when I am considering from the Month of May the C and the O values should remain the same only RUnning must be internaaly doing the calculating and shou;ld produce the result . ( Running total shoul calucute from jan and in the table when i am trying to shwo from may onwards then the output of RUnning should be added to C of May and Get subtracted from O ,

Below is my actual data :

Month	C	O
JAN	1	0
FEB	1	1
MAR	4	3
APR	2	1
MAY	0	0
JUN	8	4
JUL	12	5
AUG	10	4
SEP	5	3
OCT	6	1
NOV	3	4
DEC	8	4

OUt PUT : ( INternally QLikvie shoul calculte the formula from Janaury that is , C-O)

(If you look into the below table you see the values of C and O are directly coming from the data , but Running column is been calculted from Janaulry till Aprill )

Month	C	O	Running
MAY	0	0	3
JUN	8	4	7
JUL	12	5	14
AUG	10	4	20
SEP	5	3	22
OCT	6	1	27
NOV	3	4	26
DEC	8	4	30

Thanks