topic Re: Special number formatting in QlikView

Special number formatting

tobiasaechter — Sat, 16 Nov 2024 03:28:05 GMT

Hi,

is it possible to have numbers formatted in the following way in Qlikview?

4"293'

I have a pivot table and one expression would need a format as above.

I have tried already adding the format directly to the expression but somehow I cannot get it to work as I would like to.

In my excel template I have formatted the number like that: [>=1000]#''##0';[<=-1000]-#''##0';##0'

Now I would like to transfer this format to the dashboard.

Thanks for helping

Tobias

kaushiknsolanki — Mon, 27 May 2019 08:37:43 GMT

Hi,

You should use Num() function, like below.

Num(Expression ,'#"##0')

Regards,

Kaushik Solanki

tobiasaechter — Mon, 27 May 2019 09:19:08 GMT

That was my first guess as well but it leads to a result looking like: 4171"##0

Vengatesh — Mon, 27 May 2019 11:36:00 GMT

Maybe this

If([Your Exp]>=1000,SubField([Your Exp]/1000,'.',1)&Chr(34)&SubField([Your Exp]/1000,'.',2)&Chr(39),[Your Exp]&Chr(39))

tobiasaechter — Mon, 27 May 2019 12:53:16 GMT

thanks. That's exactly what I wanted to achieve