topic Re: Qlikview Formatting Question in QlikView

Qlikview Formatting Question

flexbox — Wed, 22 Sep 2021 03:26:38 GMT

Hi guys,

I've a .qvd which provides me columns with data and positive and negative numbers. The column with numbers is recognized as a text-string. My problem is that the negative numbers have the format e.g. 720,01- .

Is it possible to change the negative numbers in a format like this -> -720,01 ??? I've tried several things (num#() ...) with no result.

Thanks in advance.

Re: Qlikview Formatting Question

Vegar — Wed, 22 Sep 2021 04:54:02 GMT

if it is recognised as a number then it is unnecessary to reinterpret it as a num. You need to format it.

Try using num() instead of num#().

Take a look at @Jennell_Yorkman latest blog post Date# Function vs. Date Function ( https://community.qlik.com/t5/Qlik-Design-Blog/Date-Function-vs-Date-Function/ba-p/1837175 ). The same principles applies to Num# vs Num functions.

Re: Qlikview Formatting Question

flexbox — Wed, 22 Sep 2021 04:56:08 GMT

Thank's for the fast reply.

Unfortunately it's not recognized as a number 😞

Re: Qlikview Formatting Question

marcus_sommer — Wed, 22 Sep 2021 07:50:52 GMT

This should work: num(num#('720,01-', '#.#;#.#-', ',', '.'))

- Marcus

Re: Qlikview Formatting Question

flexbox — Wed, 22 Sep 2021 08:02:37 GMT

Big thx! It worked!!