Extension for Number with in Circle (Badge Color)

[neetu_singh]

Hi All,

I am looking for an extension object for an report object in Qlikview in which I can show number within color circle in pivot report as shown below.

Can anyone create or if they already have, request you to share with me.

In bottom image you can see right now, there are 3 rows but in future it might increase so am going to use pivot report but unable to achieve the right side portion.

Thanks in Advance

Neetu

[tresesco]

You can find the unicodes for the characters here: https://altcodeunicode.com/alt-codes-circled-number-letter-symbols-enclosed-alphanumerics/

You can use ALT key combination with the codes to type them. Or, use the code in Chr() in qlik to print in the screen, like:

[MarcoWedel]

[MarcoWedel]

I'm not Petter but nevertheless would like to propose some variant of his fine front end solution using a parameterized variable:

Dual(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace($1,'0','⓪'),'1','①'),'2','②'),'3','③'),'4','④'),'5','⑤'),'6','⑥'),'7','⑦'),'8','⑧'),'9','⑨'),$1)

hope this helps

regards

Marco

[MarcoWedel]

not quite the same, but maybe helpful:

Creative Ways to Display Time

[MarcoWedel]

another solution might be to bundle info load some nice circled number icons you can find in the web and switch your expression representation to image:

[MarcoWedel · Accepted solution]

yet another one using a grid chart:

hope this helps

regards

Marco

[neetu_singh]

Thanks for your help Marco & Peter. Really Appreciated

[neetu_singh]

Hi Marco,

Sorry to bother you again but am facing one problem with provided solution & wondering if you can help me out. Actually I have limited space for this chart so wanted to show five name at a time with scroll bar so that they can scroll it. But am unable to give scroll at Y-axis.

Can you please help on this.

Thanks

[MarcoWedel]

Hi again,

can you switch dimensions and scroll horizontally?

hope this helps

regards

Marco