Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

mark_costa
New Contributor III

How to format numbers in Info Bubble?

Good day,

I need to display a number in % in Info Bubble.

Can someone help me on this?

Regards,

Mark Costa

9 Replies
zhadrakas
Valued Contributor

Re: How to format numbers in Info Bubble?

Hello Mark,

try like this:

num(YourValue, '0%')

regards

tim

mark_costa
New Contributor III

Re: How to format numbers in Info Bubble?

Hi Tim,

Thank you for your reply.

I already tried that in my Measures (Expressions) - among other things - in different ways, none have worked:
1. Adding a measure and set its Number formatting as Number and in %
2. Adding the Num() in the measure Expression (as you suggested) plus the formatting in #1

3. Adding the Num() in the measure Expression (as you suggested) plus Number formatting to Auto

4. All above but using Master Measures

5. All above and forcing the Info Bubble to format only the second value displayed

Looks like Info Bubble does not recognize the format defined in the Measures and this is kind embarrassing for a tool that expensive.

Note: the Extension that I am using is the Area Layer.

Regards,

Mark Costa

zhadrakas
Valued Contributor

Re: How to format numbers in Info Bubble?

did you try to concatenate the number and %

=num(YourNumber) & '%'

or something like

text(YourNumer & '%')

regards

tim

mark_costa
New Contributor III

Re: How to format numbers in Info Bubble?

Just tried both ways, no luck.

zhadrakas
Valued Contributor

Re: How to format numbers in Info Bubble?

you could also try HTML code in this info Bubble like

<div> YourNumer & '%'  </div>

rajan_1989
New Contributor III

Re: How to format numbers in Info Bubble?

In the info bubble settings , just uncheck the 'format numbers' checkbox and it should work

mark_costa
New Contributor III

Re: How to format numbers in Info Bubble?

Hi Rajan,

I tried this already and it also does not work.
I think I will have to create a custom HTML code as Tim suggested. I'm trying to avoid that but I think it is the only way.

Thank you,

Mark Costa

Employee
Employee

Re: How to format numbers in Info Bubble?

mark.costa

Hi Mark,

If you add a blank space before or after the % it shall work@: & ' %'

To be able to add an expression to an info bubble you need to add a measure under Location ID. Then you can customize your info bubble with an expression (fx). See pictures before and after adding a measure below.

So add a measure to your Area layer if not already done and then you can open the expression editor (fx) under Appearance/Info Bubble.

Hope it helps,

Jonas

Qlik Sense InfoBubble.pngQlik Sense InfoBubble2.png

paulo_pinto
New Contributor

Re: How to format numbers in Info Bubble?

Yes, it seems that num() formula does not work.
Workaround:
Round((expr)*100,0.1) & '%'

Hope it works for you!

Community Browser