topic Re: changing the number decimals in QlikView

changing the number decimals

raadwiptec — Mon, 18 Jan 2016 14:56:23 GMT

Hi all,

My report is having a distributed to each users. Here one of the users needs to have the access to properties to change the current number from 1.23 to 1.2333

As he is the only user who required the report in that way .rest of them should see the report as 1.23 only

How could I give him the access here?

Re: changing the number decimals

sunny_talwar — Mon, 18 Jan 2016 14:58:21 GMT

May be using OSUser() function.

If(OSUser() = 'PersonX', Num(Sum(Value), '#,##0.0000'), Num(Sum(Value), '#,##0.00'))

Re: changing the number decimals

raadwiptec — Mon, 18 Jan 2016 15:10:36 GMT

hi sunny is their a possibility the user could change the decimal places himself as a option to 1.23 or 1.2333 or 1.2344

Re: changing the number decimals

sunny_talwar — Mon, 18 Jan 2016 15:16:20 GMT

Find attached a sample where a user can control the number of decimals using input box

Expression: =Num('1.2344', $(=Chr(39) & '#,##0.' & Repeat(0, vDeci) & Chr(39)))

Re: changing the number decimals

Gabriel — Mon, 18 Jan 2016 15:39:54 GMT

Hi,

One thing I will like to add to excellent suggestion from Sunny T is you can customized the InputBox to this particular user. Go to Layout and have condition show to this user and only this user will have the ability to change the format.