Special number formatting

[tobiasaechter]

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]

Hi,

You should use Num() function, like below.

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

Regards,

Kaushik Solanki

[tobiasaechter]

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

[Vengatesh · Accepted solution]

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]

thanks. That's exactly what I wanted to achieve