Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

Area chart get error msg on postive and negative value.

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

1 Solution

Accepted Solutions
mrooney
New Contributor III

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

Hi Paul,

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

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

4 Replies
paulyeo11
Valued Contributor II

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

My QV doc

paulyeo11
Valued Contributor II

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

Hi All

Can some one advise me on this ?

Paul

mrooney
New Contributor III

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

Hi Paul,

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

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

paulyeo11
Valued Contributor II

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

Hi Miguel

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

Paul

Community Browser