Generic way to add a , separator for Numeric dimensions for all fields in qlik

[Shreya1]

Hi,

I am trying to add ' ,'(comma) as a separator for all the Numeric fields(added as dimensions in the dashboard). I have found solutions mentioning to add the expression : Num(YourExpression, '#,##0') but this works only at field level. 

I have many fields/tables loaded from the load editor & its time consuming to add this expression to each field. Hence, am looking for a generic way of applying this at one go which would be applicable to all fields.

Thanks!

[Digvijay_Singh]

I don't  understand why do you need to format your numeric fields; usually we format the output of the aggregated function i.e. Sum(Value) that we show on the chart. You would create your master measures and set up the formatting there itself so that whenever you show measure value in the chart it shows up with your desired formatting. You don't need to use Num() when you create master measures, a property is available to set that up. Not sure but I think master measure formatting option is available from June 2021 release onwards..

[BrunPierre]

Unfortunately, I don't believe there's an easy way out. However, the 'find/replace' may be helpful.