topic Re: Number formatting blank after load in App Development

Number formatting blank after load

ruben_moya — Tue, 26 Apr 2022 08:52:56 GMT

Hi everyone,

I am using Qlik sense June 2018 version.

Whenever I change the values of the following parameters in the load script and the objects are set with Numeric formatting, it appears a blank option in the drill down.

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

It seems that Qlik can't automatically change the number format when the separators change.

Does anyone have any idea about how to fix this? Is this a bug?

Thanks a lot for your time.

Re: Number formatting blank after load

Andrea_Spinetti — Tue, 26 Apr 2022 14:21:27 GMT

Hello @ruben_moya, testing this on a more recent version of Qlik Sense it doesn't happen so an upgrade will most likely fix the issue 😊

Re: Number formatting blank after load

marcus_sommer — Tue, 26 Apr 2022 15:05:11 GMT

I don't think that there is a bug else there is probably just an empty value. Beside this it looked that there are various different types of values included within this field. Most often you will need to interpret and/or format them explicitly. This might be done with something like:

alt(num(num#(Value, 'Format1'), 'Format2'), num(num#(Value, 'Format3'), 'Format4'), ...) as Value

which means multiple conversions + formatting are combined and the first numeric interpretation wins.

- Marcus

Re: Number formatting blank after load

ruben_moya — Wed, 27 Apr 2022 09:19:20 GMT

Thanks a lot for your answers.

@marcus_sommer , I think we already tried all the possible options but we need the formatting to be numeric since we need the object to keep the format when exported to excel and we also need it to be dynamic.

It looks like a bug cause the blank option in the drilldown it's not an actual option, it only appears after you change the formatting parameters in the load script. It seems that in this version Qlik is not able to change the format of the measure automatically when those parameters are changed:

Number format BEFORE modifying format options in load script

Number format AFTER modifying format options in load script

Anyway, it seems that upgrading to a newer version is the only option for us.

Thanks a lot.