topic Re: Above(sum(Sales) not working in QlikView

Above(sum(Sales) not working

Anonymous — Mon, 02 Jul 2018 14:03:23 GMT

Hi All,

I am using below chart

Month	Sales	sum(Sales)	Above(sum(Sales))
		150	-
Apr	40	40	-
Feb	20	20	-
Jan	10	10	-
Mar	30	30	-
May	50	50	-

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

Re: Above(sum(Sales) not working

olivierrobin — Mon, 02 Jul 2018 14:31:03 GMT

hello

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

Re: Above(sum(Sales) not working

Anonymous — Tue, 03 Jul 2018 07:18:30 GMT

Heading used in above table is the expressions formula used

Re: Above(sum(Sales) not working

tresB — Tue, 03 Jul 2018 07:39:00 GMT

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

Re: Above(sum(Sales) not working

Anonymous — Tue, 03 Jul 2018 09:51:14 GMT

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

month1	sum(Sales)	=if(rowno(TOTAL)=1,sum(Sales),RangeSum(Above(Sales,0,rowno(TOTAL))))
	150	0
1	10	10
2	20	30
3	30	60
4	40	100
5	50	150

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

Year	month1	sum(Sales)	=if(rowno(TOTAL)=1,sum(Sales),RangeSum(Above(Sales,0,rowno(TOTAL))))
		150	0
2012	1	10	10
2012	2	20	20
2012	3	30	30
2012	4	40	40
2012	5	50	50

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