topic Re: Text Box Calculation in QlikView

Text Box Calculation

kevbrown — Fri, 30 Jan 2015 09:03:00 GMT

I have a text box with a calculation that is looking at a precentage. I would like that percentrage at 2 decimal places and not he10 it currently is, how do i limit it to 2 decimal places?

Thanks

Re: Text Box Calculation

alexandros17 — Fri, 30 Jan 2015 09:04:21 GMT

Write:

Num(myexpression, '#.##0,00 ')

hope it helps

Re: Text Box Calculation

morganaaron — Fri, 30 Jan 2015 09:04:56 GMT

Hi Kevin,

Wrap it in a num statement and specify the number of DP's:

So Num([Your Expression], '###.##%')

Re: Text Box Calculation

krishna20 — Fri, 30 Jan 2015 09:15:35 GMT

Hi,

Goto Number tab-> select Fixed to 2 decimals and enable show in Percent.

Regards

Krishna

Re: Text Box Calculation

kevbrown — Fri, 30 Jan 2015 09:30:31 GMT

Thank you