Discussion Board for collaboration related to QlikView App Development.
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
View solution in original post
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?