topic Re: Insert ascii in expression in QlikView

Insert ascii in expression

akpofureenughwu — Fri, 28 Jul 2017 13:42:38 GMT

Hello sir,

Thanks to this awesome community, I have managed to insert the naira symbol into my expression ( tables) like this

measures: chr( num#( '20A6', '(hex)') ) & money (sum(cashflow)) -------------------------------------------1

display: (Naira symbol) 4,500

But if I put this equation 1 into a pie chart or bar chart, I do get an error result (see attached)

Please can you help?

Thanks

Frank_Hartmann — Fri, 28 Jul 2017 14:32:10 GMT

chr(8358)

did you try like that?

akpofureenughwu — Fri, 28 Jul 2017 14:49:29 GMT

Helllo Frank,

Thank you for response.. I used chr(8358) but still showing error

Frank_Hartmann — Fri, 28 Jul 2017 14:57:16 GMT

is this what you want to achieve?

akpofureenughwu — Fri, 28 Jul 2017 15:12:39 GMT

This is cool but I'm on a qliksense though

Frank_Hartmann — Fri, 28 Jul 2017 15:21:53 GMT

so you have posted in the wrong section.

you are in qlikview forum!

akpofureenughwu — Fri, 28 Jul 2017 15:24:09 GMT

sorry.... Let me exit this forum

Thanks Frank