topic Positive and Negative #s in Block Chart in QlikView

Positive and Negative #s in Block Chart

jdmarlin — Tue, 08 Sep 2015 18:22:07 GMT

I've created a block chart where the block size is calculated with the following expression: Fabs(Sum({$<Date={'$(=vMaxDate)'}>} Value)

I'm trying to use the Dual function so that when you hover over a block a positive or negative number will appear:

Dual('Market Value: ' & Num(Sum({$<Date={'$(=vMaxDate)'}>} Value),'##,###.00'), Fabs(Sum({$<Date={'$(=vMaxDate)'}>} Value)))

But a negative number still appears as a positive number when I hover over a block.

I've used this formula before in other QV apps, but for some reason it doesn't appear to be working in this one.

Thanks for any help!

maxgro — Tue, 08 Sep 2015 18:34:02 GMT

did you see the "Market Value:"?

if not check in number tab the number format is set to expression default

jdmarlin — Tue, 08 Sep 2015 18:49:21 GMT

I've been wracking my brain for an hour over this! Setting number format to Expression Default solved it. Thanks!