Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Contributor III
Contributor III

Hi Paul,

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

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

View solution in original post

4 Replies
paulyeo11
Master
Master
Author

My QV doc

paulyeo11
Master
Master
Author

Hi All

Can some one advise me on this ?

Paul

mrooney
Contributor III
Contributor III

Hi Paul,

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

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

paulyeo11
Master
Master
Author

Hi Miguel

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

Paul