topic Re: Chr() for Man Symbol in QlikView

Chr() for Man Symbol

derekjones — Fri, 23 May 2014 11:37:09 GMT

Hi All

Does anyone know if there is a Chr() for a man symbol (either stick man or the type of man symbol found on Toilet door etc). I've searched high and low and cannot find it. I've found a snowman chr(9731) so a man symbol must exist shouldn't it?

My thanks in advance for any response.

Derek

Re: Chr() for Man Symbol

rbecher — Fri, 23 May 2014 11:56:45 GMT

Hi Derek,

I found this:

Unicode Character 'WOMENS SYMBOL' (U+1F6BA) => chr(128698)

Unicode Character 'MENS SYMBOL' (U+1F6B9) => chr(128697)

But it will not be displayd.. Maybe you can use these:

Unicode Character 'FEMALE SIGN' (U+2640) => chr(9792)

Unicode Character 'MALE SIGN' (U+2642) => chr(9794)

- Ralf

Re: Chr() for Man Symbol

rbecher — Fri, 23 May 2014 11:58:32 GMT

Btw. an overview of Miscellaneous Symbols in unicode: http://www.unicode.org/charts/PDF/U2600.pdf

Re: Chr() for Man Symbol

derekjones — Fri, 23 May 2014 12:18:13 GMT

Thanks Ralf

That's a shame it won't display. Do you know the font, maybe I can change the font so it can display?

Thanks again

Derek

Re: Chr() for Man Symbol

rbecher — Fri, 23 May 2014 12:28:02 GMT

I don't think it's a font related issue.. Maybe you can use an image instead?

Re: Re: Chr() for Man Symbol

derekjones — Fri, 23 May 2014 13:36:05 GMT

Found a workaround, webdings chr(128) is a man symbol. See below for an example of it working in my app...

Thanks again for your help. Got there in the end!

Derek

Re: Chr() for Man Symbol

antose — Tue, 27 May 2014 11:23:12 GMT

I use Ariel as font.

Re: Chr() for Man Symbol

Wed, 27 Aug 2014 14:38:36 GMT

Question for Derek Jones:

Derek, how did you change the colour of the men within a row? What underlying object are you using please?

Re: Chr() for Man Symbol

Sat, 31 Oct 2015 07:58:42 GMT

Hi Derek,

Am very interested in your stick man graph. How did you create this? Is it a liner gauge chart?

I'm quite new to Qlikview so would appreciate it if you can provide more details.

Thanks

Sim

Re: Chr() for Man Symbol

derekjones — Sun, 01 Nov 2015 12:23:44 GMT

Hi Sim

I've attached a simple example of how I've got it working. As you can see the stick men dynamically change in number to match the number of employees e.g. Select Team A and it shows 5 men and select Team B and it shows only 2.

Hope this helps

Derek

Re: Chr() for Man Symbol

derekjones — Sun, 01 Nov 2015 12:55:54 GMT

Hi Jonathan

Sorry I missed your question about a year ago. Someone else has asked recently, so I've posted an example of it working. Hope this helps answer your question.

Apologies again for not responding sooner.

All the best

Derek

Re: Chr() for Man Symbol

Mon, 02 Nov 2015 01:51:35 GMT

Derek, thank you so much!!

Just one more question - the number of people I have on this stickman chart is more than 5. I have around 200 people max. Is there anyway that I can move the stickmen into rows such that each row will have 20 men?

Thanks,

Sim

Re: Chr() for Man Symbol

derekjones — Mon, 02 Nov 2015 09:46:44 GMT

Hi Sim

Does the 200 employees have any sort of grouping like Team or Area etc, then you could do one row per Team/Area?

Unfortunately the chart cannot be pivoted as it's a straight table with hidden fields (As the font is webdings so would make no sense). You could number the reps then do a chart for 1-20, 21-40 etc and stack them?

Best regards

Derek