Discussion Board for collaboration related to QlikView App Development.
Dear All,
Need help one the over come the problem. Like Output Need Like Last column.
Please help me..
OrderDate | sum(Sales) | rangesum(above(sum(Sales),0,rowno())) | Output Need Help |
83689.15 | 0 | ||
04/10/2008 | 2555.52 | 2555.52 | 2555.52 |
22/10/2008 | 400.28 | 2955.8 | 2955.8 |
23/10/2008 | 1598.57 | 4554.37 | 4554.37 |
24/10/2008 | 23973.49 | 28527.86 | 28527.86 |
26/10/2008 | 297.19 | 28825.05 | 28825.05 |
30/10/2008 | 155.17 | 28980.22 | 28980.22 |
31/10/2008 | 1242.1 | 30222.32 | 30222.32 |
06/11/2008 | 2639.56 | 32861.88 | 2639.56 |
10/11/2008 | 4952.4 | 37814.28 | 7592 |
30/11/2008 | 6253.93 | 44068.21 | 13846 |
01/12/2008 | 946.07 | 45014.28 | 946.07 |
02/12/2008 | 8523.22 | 53537.5 | 9469 |
03/12/2008 | 4341.18 | 57878.68 | 13810 |
10/12/2008 | 2424.95 | 60303.63 | 16235 |
21/12/2008 | 826.94 | 61130.57 | 17062 |
27/12/2008 | 587.14 | 61717.71 | 17650 |
29/12/2008 | 21971.44 | 83689.15 | 39621 |
I think what you are describing should be the default behaviour of QV, considering the column segments in a chart to reset the accumulation. See attached.
I think what you are describing should be the default behaviour of QV, considering the column segments in a chart to reset the accumulation. See attached.
If pivot table is an option, adding Month_Year field as the first dimension could the solution.
without Month Year field , it will calculate the same .......?
Thanks for reply, without month year filed it will calculate .... ?
Not by default, but you can check in your expression for a change in month.
See attached sample.
Thanks for reply,
If I add the one more expression on the same table like QTD also it work ?
It should work also with other expressions. How does your QTD expression look like?
Thanks a lot
thanks a lot