Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Chanty4u
Esteemed Contributor III

Re: Negative values in chart

Arjunarao
Honored Contributor II

Re: Negative values in chart

Hi manojkulkarni ,

Thanks for your advise. I need to show negative mouse over values in brackets.

MVP & Luminary
MVP & Luminary

Re: Negative values in chart

Hi,

Check this link

How to create a pie chart with positive and negative values

OR try this expression

=dual(fabs(sum(sales)),Sum(sales))

Regards,

Jagan.

Highlighted
Partner
Partner

Re: Negative values in chart

Hi Arjun,

How did you solve this problem ? Please share the solution

Arjunarao
Honored Contributor II

Re: Negative values in chart

Hi Manoj,

This is the celambarasansolution.

If(Sum(Sales)<0, Num(Fabs(Sum(Sales)), '(#,###'), Num(Sum(Sales), '#,###')

Partner
Partner

Re: Negative values in chart

Thanks Arjun.

Partner
Partner

Re: Negative values in chart

PFA...