Discussion Board for collaboration related to QlikView App Development.
I have a bar chart
from date 25 it has 2000 value it bas been added to 26th and 25th,26th data is added to the 27 so ...on now on next month the same process is not getting so what will be the expression to achieve if 1dec has value 500 it should show 500 then in 2nd dec it has 1000 it should show 1500 likewise
below is my expression used in chart
sum(DISTINCT aggr(rangesum(above(TOTAL sum(NET_WEIGHT),0, Rowno())),MONTH_EXCISE_INVOICE_DATE,EXCISE_INVOICE_DATE))
Hi Manesh, maybe removing the 'Distinct' clause?
Which value is returning now and which value is expected for 1st and 2nd of the month?
May remove the TOTAL keyword and see if that helps...
Sum(DISTINCT Aggr(RangeSum(Above(Sum(NET_WEIGHT), 0, RowNo())), MONTH_EXCISE_INVOICE_DATE, EXCISE_INVOICE_DATE))
Implemented both of your suggestion not working anything else???
1st month values what is actually required and I m getting
for 2nd month the expression is required from your expertise...
omarbensalem any idea for the requirement.
maybe you could try with full accumulation of the chart expression.
In order to restart the accumulation per month you might use the month field as second dimension, stack the second dimension (as one date cannot belong to two months there will only ever be one segment per stack), restrict to a common color and turn off the legend. The result could look like this:
MonthName(EXCISE_INVOICE_DATE) as MONTH_EXCISE_INVOICE_DATE
hope this helps