Discussion Board for collaboration related to QlikView App Development.
Hello,
I need to do an acummulative expresion in a graph from the expression: Sum(distinct sales).
the only dimension in the graph is year.
hoping you can help me
rangesum(above(sum(distinct sales),0,RowNo()))
rangesum(above(sum(distinct sales),0,RowNo()))
Its not a good idea to do distinct sum of sales... What if you have data like this
Year Employee Sales
2010 Shyam 50
2010 Ram 50
2010 Rakesh 70
Sum(DISTINCT Sales) = 120, I don't think you would want this, do you?