PV table Substract

[pgalvezt]

Hello, Is it possible to obtain the substract of 1 Expression into a new row in QlikView?

What I want is may - Abr.

Thank you

[swuehl · Accepted solution]

Try with chart inter record functions, like above(), below(), before(), after(). In your case, I would maybe try something like:

=sum(FIELD)- before(sum(FIELD))

[pgalvezt]

Thank you swuehl for your reply works fine, just one question When I try to build a bar char with this formula nothing happend. Maybe few data, or negative values?

Thanks

[swuehl]

before() and after() are only useful in pivot tables, with at least one dimension pivoted to the top. In other chart types, the functions return NULL.

Try using above() instead in your bar chart.

[pgalvezt]

Ok! Many Thanks.