topic Re: Dynamic Number Formatting in QlikView

Dynamic Number Formatting

rnepla83 — Tue, 07 Apr 2015 16:00:34 GMT

Hi to all,

System allow user to manage some system variables by like:

SET ThousandSep=',';

SET DecimalSep='.';

Using 2 buttons am I able to change dinamically the numbers formatting into the RESULT TABLE?

Please see the attached below to understand better my problem.

Thank you a lot.

Paolo.

Re: Dynamic Number Formatting

Wed, 08 Apr 2015 03:21:36 GMT

Hi Paolo,

The system variables are only updated when a reload is performed so I do not think that will give you the dynamic ability you are after.

What I have done is add three new variables (format, decimal separator and thousand separator) and mapped these to your buttons. In the table I have set the number format to Expression Default and modified the expression to include the Num function which calls in the values stored against the variables and allows for the dynamic formatting to work.

Hope this helps.

Kind regards,

Rod

Re: Dynamic Number Formatting

rnepla83 — Wed, 08 Apr 2015 09:20:15 GMT

Hi Rod,

thank you so much for your answer. I was thinking to the same solution but i suppose to use the system variable to avoid to change each expression in my BI. But now i am seriously thinking that is not possible.

Thanks a lot.

Best regard.

Paolo.

Re: Dynamic Number Formatting

awhitfield — Wed, 08 Apr 2015 09:24:24 GMT

Hi Paolo;,

a bit late, but here's another option for Q1

Andy

Re: Dynamic Number Formatting

rnepla83 — Wed, 08 Apr 2015 10:20:15 GMT

Thank you a lot.

Best regards.

Paolo.

Re: Dynamic Number Formatting

amezzaro — Mon, 13 Apr 2015 16:07:05 GMT

Hi All,

as a result of what has been remarked here, the only possibility for Qlik View to dynamically change number format,or dates format, which would be usefull in multi country projects, is to use the Num function (or Date function).

Of course this limitation has some side effect: each Expression (or Dimension containing dates) in the QVW application must be set up as a Num-function-expression, however this is not correctly manged by QV for bar chart axis, where it seems that the Default number expression is used instead of the Expression format.