topic Re: How can I use the previous value on a simple table? in QlikView

How can I use the previous value on a simple table?

Tue, 13 Sep 2016 01:53:25 GMT

Hi!

I need to use the previous value from the same colum.. like this..

first I get the MAX(TM CAUSA) , then i put this value in the same row. for the next rows in TM ACUM should be the previous value + TM CAUSA.

I tried whith ABOVE() but it has a problem whit the order: When I use the Above() function, doesn't permit to order values. Why?

MAX(TM CAUSA) = max(total AGGR(sum( {<PLANTA={'xx'} >} CANTABS),ORIGEN,CAUSA)))

Re: How can I use the previous value on a simple table?

sunny_talwar — Tue, 13 Sep 2016 05:05:06 GMT

Try this:

RangeSum(Above(TOTAL Max(TM CAUSA), 0, RowNo(TOTAL)))

Re: How can I use the previous value on a simple table?

Tue, 13 Sep 2016 13:31:34 GMT

it returned 0, but Above() doesn´t permit to order by column

Re: How can I use the previous value on a simple table?

sunny_talwar — Tue, 13 Sep 2016 15:46:39 GMT

Not sure I understand, can you elaborate as to what went wrong?

Re: How can I use the previous value on a simple table?

Tue, 13 Sep 2016 17:05:51 GMT

I need TM Causa in descending order, like this...

When I use Above() the order is missing.

because.. When I use the Above() function, doesn't permit to order values. Why?

I need to reproduce this:

Re: How can I use the previous value on a simple table?

sunny_talwar — Tue, 13 Sep 2016 20:39:12 GMT

AFAIK this is definitely a limitation and the only work around I can think of is to sort the table in the back end of the application and use Aggr() function. But this still might not behave well with selections as script sort order won't change based on selection. A lot of us are hoping that this comes up in the future releases of QlikView/ Qlik Sense

‌. What you can do is sort by dimensions in Aggr and not by expressions -> The sortable Aggr function is finally here!