Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Restrict the values to two decimals

Dear all,

When I hover a chart the values should be integer or fixed to 2 number.

In my expression i formatted the number as auto and checked the value on data points and it displays the values in millions but when i hover it shows all decimals.

PFA for screenshot.

Regards,

Joshua.

8 Replies
prma7799
Master III
Master III

Have you tried this with your expression

Num(Sum(Sale), '##.##')

Or please share sample app

ajsjoshua
Specialist
Specialist
Author

Hi PM,

When we use this Num(Sum(Sales), '##.##') and hover the chart it shows sales value 3 times

like sales:276.2 M

sales:276358049.82

sales:276358049.8199878

prma7799
Master III
Master III

Please share sample app.

francescoreggia
Partner - Contributor III
Partner - Contributor III

try

round(Sum(Sales),0.01)

OmarBenSalem

U have  expressions; maybe the revenue one is mis formatted

format it as a number

ajsjoshua
Specialist
Specialist
Author

Hi PM

PFA for sample app.

when we hover it should show only one sales.Here in this sample it will show two sales.

OmarBenSalem

Name the label of your color by measure EXACTLY like the label of ur measure.

Capture.PNGCapture.PNG

result:

Capture.PNG

If they're not named exactly identical:

example:

Capture.PNG

It will show it 2 times even if it's the same measure u're using in both measure and color by measure (sum(Sales)):

Capture.PNG

ajsjoshua
Specialist
Specialist
Author

Hi Omar,

Thanks for ur reply.

Even if i name same label to both expression still it shows sales two times.