topic Re: Area chart get error msg on postive and negative value. in QlikView

Area chart get error msg on postive and negative value.

paulyeo11 — Wed, 27 Aug 2014 08:37:35 GMT

Hi All

Below SET expression working fine in table .

money(

if([Exec P&L Level] = 's','',

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} Amount/1000/$(ColumnDim98))

)

, $(vMoneyFormatK_GL))

when i convert to area chart , i get error msg :-

Positive and negative value in chart.

any solution ?

Paul

paulyeo11 — Wed, 27 Aug 2014 08:39:20 GMT

My QV doc

paulyeo11 — Thu, 28 Aug 2014 13:31:00 GMT

Hi All

Can some one advise me on this ?

Paul

mrooney — Sat, 30 Aug 2014 15:53:57 GMT

Hi Paul,

you need to use the Abs() function to solve this issue. It also happens in pie chart.

Abs(Sum(.....)).

paulyeo11 — Mon, 01 Sep 2014 12:19:55 GMT

Hi Miguel

Thank you very much. I try with FABS and it work fine now.

Paul