Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
prince_panghal
New Contributor III

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
Valued Contributor III

Re: Above(sum(Sales) not working

hello

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

Highlighted
prince_panghal
New Contributor III

Re: Above(sum(Sales) not working

Heading used in above table is the expressions formula used

Highlighted
MVP
MVP

Re: Above(sum(Sales) not working

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))

Highlighted
prince_panghal
New Contributor III

Re: Above(sum(Sales) not working

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.