Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jdmarlin
Contributor III
Contributor III

Positive and Negative #s in Block Chart

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!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

did you see the "Market Value:"?

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

View solution in original post

2 Replies
maxgro
MVP
MVP

did you see the "Market Value:"?

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

jdmarlin
Contributor III
Contributor III
Author

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