Required Cumulative values

[#1]

Hi All,

I need to figure out the outstanding amount till date. PFA the excel file, in that file positive amount specifies the invoice and negative amount prescribes the sales, sum of Invoice - Payment will be my outstanding. Based on the selection of dates by the user, the chart should show me past twelve months data. I need a cumulative value of the records. For Example, if the user select 17-Apr-14, then my data should be as follows:

Month	Outstanding (in Lakhs)
Apr	2.57
May	0
Jun	1.56
Jul	2.23
Aug	2.44
Sep	1.1
Oct	0.74
Nov	1.49
Dec	1.49
Jan	1.06
Feb	0.31
Mar	0.74

Please help!!!!!!!!!!

Thanks,

Sabareetha M.P

[sujeetsingh]

What you really want can you plz explain or post sample

[#3]

I wanted to have a line graph, based on the user input, the month and customer name should be dimension and Outstanding amt is expression. I have already specified the data required as example.

[MK_QSL]

Like this?

[#5]

Hi Manish,

Thanks a lot, but this does not solve my query. It gives me a data wrt the particular month, but I need a cumulative data. I require the same data, that I have mentioned in my first mail. Please help!!!!!!!!!!

[#6]

the easiest way is through the Accumulation property in the chart properties

[#7]

I tried, but its giving some different result, I have two dimensions namely, customer name ,month and an expression to retrieve the amount. I selected today’s date and the chart will be from the month of Apr 2013 to Mar 2014, for Apr 2013, it shows me only -0.57 Lakhs and May 2013 -2.57 Lakhs,  if I specify accumulate in Chart, for Apr the value keeps unchanged, but for May it gives me -3.14 i.e. (-0.57+(-2.57)). Please suggest.

[#8]

can you upload your qlikview document?

[#9]

Sorry, I am new to qlikview and document has been linked with server. I am not aware how to retrieve and send the particular scripts, therefore, I just created a sample file for your reference and attached the same. Please check whether this helps!!!