How to get comma seperated number value in custom tool tip of Qliksense Line Chart

[varaprasad0816]

Hi,

How to get comma (,) seperated number value format  in custom tool tip of Vizlib line chart as mentioned below.

Ex: 

62446 > 62,446

I have written like num(fieldname, '#,##0') 

but which is not working.

Request you to kindly let me know how to achieve my requirement.

Please find attached screenshot for your reference.

Regards,

Vara

[sunny_talwar]

This has worked for me in the Pivot table

Num(fieldname, '#,##0;(#,##0)')

[varaprasad0816]

Hi Sunny,

Thanks for your quick response on this.

I have tried with your expression but which is not working.

As you know that I have been given condition / expression  in "Custom Tool tip" in Vizlib Pie Chart.

I am getting value like this (31281,##0) but  I need like 31, 281

Please find attached screenshot for your reference.

Regards,
Vara

[sunny_talwar]

I am not sure why this doesn't work for you as this works without any issues for me. May be if you can share a sample we might be able to look into it

[varaprasad0816]

Hi Sunny,

I took normal dimension and measure (All Treaters, HCP).

Bu default I am getting values for All treaters in tool tip.

As per requirment, we need to show some custom values hence putting expression in custom tool tip where we need comma seperated value for all numbers. 

tried with Num(Fieldname, '#,##0;(#,##0)') but which is not working.

I am not able to provide sample data as working in remotely. sorry for that.

Can you please look into custom toll tip expression number format with comma seperated.

Attached same screenshot for your reference.

Regards,

vara

[varaprasad0816]

Hi Sunny,

I took normal dimension and measure (All Treaters, HCP).

Bu default I am getting values for All treaters in tool tip.

As per requirment, we need to show some custom values hence putting
expression in custom tool tip where we need comma seperated value for all
numbers.

tried with Num(Fieldname, '#,##0;(#,##0)') but which is not working.

I am not able to provide sample data as working in remotely. sorry for that.



Can you please look into custom toll tip expression number format with
comma seperated.

Attached same screenshot for your reference.



Regards,

vara

[varaprasad0816 · Accepted solution]

Hi,

I got it with below expression.

Num(Fieldname, '#,##0','.'',')

Regards,

Vara