topic Re: Conditional decimals formatting by user in App Development

Conditional decimals formatting by user

dcollmed — Wed, 22 Nov 2017 17:22:31 GMT

Hello everyone,

I have a Dashboard in which users from different countries will access. These users want to see the decimal formatting differently. Ones with a comma as decimal and others with a dot.

For the thousands, the opposite.

Is it possible to do it? I already have a section access document.

I have been playing around with the osuser function, but I do not find a proper solution.

Thank you in advance.

Re: Conditional decimals formatting by user

Anonymous — Wed, 22 Nov 2017 18:00:10 GMT

Maybe have a button to set a variable that defines the number format either comma or dot and then explicitly use that variable definition with the num() function in your viz expressions. Then users can manually select whichever format they wish.

I think there are suitable button extensions on Qlik Branch

Re: Conditional decimals formatting by user

marcus_sommer — Thu, 23 Nov 2017 13:04:01 GMT

Maybe this is helpful: handling timezones and formats for date/time,number and money.

- Marcus

Re: Conditional decimals formatting by user

dcollmed — Thu, 23 Nov 2017 15:39:27 GMT

Thank you for your answer.

However, I would like to avoid making this change on each measure, as in the whole application there are like 200 of them. I was thinking about changing anything on the initial script editor, where the following properties are set:

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

But something with OSUser() or section access file?

Thanks in advance

Re: Conditional decimals formatting by user

dcollmed — Thu, 23 Nov 2017 15:45:35 GMT

Thanks for your help.

But it seems it would require changing all metrics using that variable...

I was looking into something I could only set once and would work for all the Dashboard, since I use around 200 measures.

Thanks again!

Re: Conditional decimals formatting by user

marcus_sommer — Thu, 23 Nov 2017 16:08:39 GMT

I think there is no easier way. Normally should such a requirement considered before an application is developed because afterwards are changes sometimes quite painful ...

Having said this - you could go into the expression-overview and change all (or at least most) of your measures there, even with a search- and replace-feature but this will need some efforts, too and by using of the replace-feature you need to be very careful not to change anything unwanted ...

ps. A backup would be quite comforting.

- Marcus

Re: Conditional decimals formatting by user

Anonymous — Thu, 23 Nov 2017 16:35:10 GMT

Is there an expression overview in Qlik Sense similar to QlikView ?

Re: Conditional decimals formatting by user

marcus_sommer — Fri, 24 Nov 2017 06:38:49 GMT

No, I don't think it is yet - I haven't noted that this was posted in a Sense forum.

- Marcus