topic Re: PV table Substract in QlikView

PV table Substract

pgalvezt — Mon, 13 Aug 2012 22:04:47 GMT

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

Re: PV table Substract

swuehl — Mon, 13 Aug 2012 22:23:22 GMT

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

Re: PV table Substract

pgalvezt — Tue, 14 Aug 2012 13:29:40 GMT

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

Re: PV table Substract

swuehl — Tue, 14 Aug 2012 13:33:01 GMT

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.

Re: PV table Substract

pgalvezt — Tue, 14 Aug 2012 13:39:57 GMT

Ok! Many Thanks.