Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Above(sum(Sales) not working

Hi All,

I am using below chart

  

MonthSalessum(Sales)Above(sum(Sales))
150-
Apr4040-
Feb2020-
Jan1010-
Mar3030-
May5050-

Why Above(sum(sales)) is not working here

4 Replies
olivierrobin
Specialist III
Specialist III

hello

could you post a piece of data and the formulas you used in your graph ?

Anonymous
Not applicable
Author

Heading used in above table is the expressions formula used

tresesco
MVP
MVP

It seems that you have used Sales as a dimension. Either remove it from dimension, then the same expression would work. Otherwise, use the following expression: =Above(total sum(sales))

Anonymous
Not applicable
Author

Thanks Tresesco,

It is coming fine now .Idea was to find the cumulative sum . It is working fine if i am bringing month1 column only as below

month1sum(Sales)=if(rowno(TOTAL)=1,sum(Sales),RangeSum(Above(Sales,0,rowno(TOTAL))))
1500
11010
22030
33060
440100
550150

But if i am bringing dimesnion Year as well then its not required result as above

  

Yearmonth1sum(Sales)=if(rowno(TOTAL)=1,sum(Sales),RangeSum(Above(Sales,0,rowno(TOTAL))))
1500
201211010
201222020
201233030
201244040
201255050

Could you please tell me why its showing this behavior by adding a new dimension to the chart.