topic Re: Show Last value for a Cumulative Line in QlikView

Show Last value for a Cumulative Line

Mon, 25 Mar 2013 15:28:44 GMT

I have a Chart where I want to showthe total cumulative value once its reached at the the end.

I was able to Show Max / Min values for the Bars but NOT the Cumulative. Any assistance would be great.

The formula I used is this: the first part is to get Rank of 1 test if when it = Summation then output Total value.

If(Rank(RangeSum(above(Sum( RevAmt),0,RowNo()))) = 1 , Sum({1} TOTAL RevAmt) )

I then use the Show Value option like this.

See attahced.

Re: Show Last value for a Cumulative Line

Gysbert_Wassenaar — Mon, 25 Mar 2013 15:38:38 GMT

You want to show the value of the expression for the last value of the x-axis dimension. Can't you use max to test for that? if(max([Rev Months])=[Rev Months],1,0)

Re: Show Last value for a Cumulative Line

Mon, 25 Mar 2013 15:50:31 GMT

No luck. Tried this. if(max(RevMonth)=RevMonth, Sum({1} TOTAL RevAmt),0)

Seems simple but proving not to be for Cumulative.

I can draw a Cumulative line using this: RangeSum(above(Sum( RevAmt),0,RowNo()))

So I figured I would use that to Compare against my total value which outputs the correct total. Instead it outputs for every plot point.

Re: Show Last value for a Cumulative Line

Mon, 25 Mar 2013 17:31:46 GMT

I was able to get this expression to show but plots incorrectly.

If(Sum( RevAmt) = RangeSum(above(Sum(RevAmt),0,RowNo())) , Sum( TOTAL RevAmt) )

Re: Show Last value for a Cumulative Line

Gysbert_Wassenaar — Mon, 25 Mar 2013 17:47:36 GMT

See attached example

Re: Show Last value for a Cumulative Line

Mon, 25 Mar 2013 18:08:08 GMT

Nice, I see what you meant before but more so. Instead use the Text vs Show Value. Thanks.