Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tuxo9999
Contributor II
Contributor II

Cumulative Expression in Graph

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

2 Replies
Anonymous
Not applicable

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

View solution in original post

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?