Yeah i need something like this but can you please help me to create this by using attached sample data.
There are 2 sheet in the attached excel file.
1) Data input- this is how i have data in my source table.
2) OUTPUT- in this sheet i have created 3 section Green/Yellow/Red. T !he behavior is in Green section, if number is greater than 0 then it should be within green circle & if it is 0 then it should be in "Gray" circle.
My name isn't Marco but I think I can give you an answer as well ....
No there isn't - you can also easily do it dynamically in the UI without doing anything in the load script. Have a look at the attached QlikView application I made. I just made two variables - with some strange looking names and reference them with $-sign expansion before and after the expression or number I want to convert to numbers with circled digits.
You don't have to use Dual() here - I just used it to be able to still use the number in calculations in the chart for other expressions and or totals. You could simply have $(<circles>) Sum(N) $(</circles>)
No ASCII is not used but a relative or successor if you like of ASCII which is Unicode or the specific Unicode character set named UTF-8. Original US ASCII had only 127 characters Unicode has in version 6.0 109.384 characters mapped and can possibly contain more than a million different characters (later on).
Using Chr() function in QlikView or Qlik Sense you can give the Unicode character number which can be quite high numbers.
This web site is a place where you can explore the Unicode characters:
There are many of these helpful sites out there that let you explore the universe of Unicode... Just google Unicode and UTF8 and you will find this one as well: Unicode Character Ranges as tens of others ...