QlikView App Dev

[tuxo9999]

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

[Anonymous · Accepted solution]

rangesum(above(sum(distinct sales),0,RowNo()))

[sunny_talwar]

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?