Expression interpretation

[Anonymous]

Hi there,

I'm copying an expression made by someone but was wondering if someone could tell me what the end of it (highlighted) means/is doing

Thanks!

[dplr-rn]

the '#.0' is for format. num function is to output a number in a desired format

e.g. = num(10000,'#.0') gives output 10000.0

num(10000,'#,##0.0') gives 10,000.0

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/Formattin...

not sure if you meant to include the other 0 in your highlight thats the else option for count>100 i.e. 0 if count is less than or equal to 100