Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ajsjoshua
Contributor III

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
Honored Contributor III

Re: Restrict the values to two decimals

Have you tried this with your expression

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

Or please share sample app

ajsjoshua
Contributor III

Re: Restrict the values to two decimals

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
Honored Contributor III

Re: Restrict the values to two decimals

Please share sample app.

francescoreggia
New Contributor III

Re: Restrict the values to two decimals

try

round(Sum(Sales),0.01)

OmarBenSalem
Esteemed Contributor

Re: Restrict the values to two decimals

U have  expressions; maybe the revenue one is mis formatted

format it as a number

ajsjoshua
Contributor III

Re: Restrict the values to two decimals

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
Esteemed Contributor

Re: Restrict the values to two decimals

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
Contributor III

Re: Restrict the values to two decimals

Hi Omar,

Thanks for ur reply.

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

Community Browser