Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What you really want can you plz explain or post sample
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.
Like this?
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!!!!!!!!!!
the easiest way is through the Accumulation property in the chart properties
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.
can you upload your qlikview document?
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!!!