topic Num() format for positive/negative values along with symbols in QlikView

Num() format for positive/negative values along with symbols

afbraga1 — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I am trying to attribute symbols (up/down triangle) when formatting a number with the num() function. I mange to get the correct values (333%) when I place the chr() symbols before the format type, but not when I place them after (I get 3%). I don't seem to find what's wrong and the correct nomenclature. May someone shed a light and help here, please? Can check this on my example below. Thank you!

Re: Num() format for positive/negative values along with symbols

sunny_talwar — Thu, 01 Feb 2018 15:11:12 GMT

Not sure why it behaves this way, but a work around

=num(10*100/3, '##0%' & CHR(9650) & ';' & '##0%' & CHR(9660))

Re: Num() format for positive/negative values along with symbols

devarasu07 — Thu, 01 Feb 2018 15:15:23 GMT

Hi,

Have you tried like this?

=Num(10/3,'▲ #,##0;▼ #,##0')

and add your text color expression as

if(10/3=1,Green(),Red())

Re: Num() format for positive/negative values along with symbols

afbraga1 — Thu, 01 Feb 2018 15:31:35 GMT

My issue is that I want the symbols before not after the format type

Re: Num() format for positive/negative values along with symbols

sunny_talwar — Thu, 01 Feb 2018 15:40:27 GMT

Did you look at what I provided?

Re: Num() format for positive/negative values along with symbols

afbraga1 — Thu, 01 Feb 2018 15:53:30 GMT

Strangely it works yeah . I thought it wasn't gonna work because in my real cases it ended up giving me 0 as a value, but apparently multiplying by 100 makes it return the correct value again.

Re: Num() format for positive/negative values along with symbols

afbraga1 — Thu, 01 Feb 2018 16:44:55 GMT

Any idea if the format can be extended to evaluate null values?

Re: Num() format for positive/negative values along with symbols

sunny_talwar — Thu, 01 Feb 2018 17:13:54 GMT

What do you mean, can you elaborate?

Re: Num() format for positive/negative values along with symbols

afbraga1 — Thu, 01 Feb 2018 17:52:05 GMT

Ah nevermind, it didn't make sense what I was thinking. For a sec I totally forgot about the Null Symbol in Presentation tab.