topic Re: Last row as total in QlikView

Last row as total

Anonymous — Wed, 11 Nov 2015 10:15:12 GMT

Hi,

how can i display the last row in a straight table as total?

Example:

Date	50
11-01-2015	4
11-02-2015	10
11-03-2015	90
11-04-2015	2
11-05-2015	50

Greetings

Phil

Re: Last row as total

Mark_Little — Wed, 11 Nov 2015 10:19:26 GMT

Hi,

Within the chart properties > Presentation you have the totals section.

Mark

Re: Last row as total

Anonymous — Wed, 11 Nov 2015 10:30:08 GMT

Hi Mark,

thx for your reply. But thats not what i want.

The Row for Totals should be on the first Row. But the value that is displayed there, should be the value of the last row in the table. Like in my example.

Re: Last row as total

miguelbraga — Wed, 11 Nov 2015 10:30:46 GMT

Find this attached file:

Re: Last row as total

Anonymous — Wed, 11 Nov 2015 10:37:01 GMT

Hi Braga,

It shows 156 as total in your Example. But instead it should show 50, because thats the "newest" value in respect of date....

Re: Last row as total

miguelbraga — Wed, 11 Nov 2015 10:41:38 GMT

This?

Re: Last row as total

miguelbraga — Wed, 11 Nov 2015 10:43:58 GMT

See my answer above . It is the solution for your problem in a simple and clean way

Re: Last row as total

sunny_talwar — Wed, 11 Nov 2015 10:44:05 GMT

May be try this expression (using Braga's complied QVW file)

=FirstSortedValue(Aggr(Sum("50"), Date), -Date)

Re: Last row as total

Anonymous — Wed, 11 Nov 2015 15:10:42 GMT

Sorry, this isnt working for me because i cant calculate these fields in script.

There is an expression for this column. If you select 11-01-2015 to 11-13-2015 then it should show the value of 11-13-2015 als total. If you select 05-01-2015 to 05-24-2015 then it should show the value of 05-24-2015 as total.

Re: Last row as total

sunny_talwar — Wed, 11 Nov 2015 15:15:22 GMT

Have you looked at the FirstSortedValue solution provided below?

Re: Last row as total

Anonymous — Wed, 11 Nov 2015 15:18:59 GMT

Yes, tried in the .qvw you provided. Seems like the right direction.

Will try it tomorrow in my .qvw.

Re: Last row as total

sunny_talwar — Wed, 11 Nov 2015 15:24:01 GMT

Sounds like a plan