topic Re: Formating Text in QlikView

Formating Text

ThabisoPaul — Sat, 16 Nov 2024 03:04:28 GMT

Hi Guys,

I want to format my text to show only 2 decimal places

=num(num(num(num(Num(sum({<Report_MonthT={'$(=Month(date(MonthStart(today()))))'}>} Offered), '#,##0.','.',',')

Num(sum({<Report_MONTH={'$(=month(max(MonthName(Report_Date))))'}>} Abandoned+[Transfered]), '#,##0.','.',','))

Num(sum({<Report_MonthT={'$(=Month(date(MonthStart(today()))))'}>} Offered), '#,##0.','.',','),0 & '%'))) *100

Re: Formating Text

olivetwist — Mon, 08 Jul 2019 13:09:52 GMT

it looks to me like you have got overkill with formatting.

do your equation in full and apply formatting around it like below:

num(
(sum({<Report_MonthT={'$(=Month(date(MonthStart(today()))))'}>} Offered)
-sum({<Report_MONTH={'$(=month(max(MonthName(Report_Date))))'}>} Abandoned+[Transfered]))
/
sum({<Report_MonthT={'$(=Month(date(MonthStart(today()))))'}>} Offered)
,'#.##')

Re: Formating Text

ThabisoPaul — Mon, 08 Jul 2019 13:21:03 GMT

Hi,

I Re -structured the script and removed all the Formats and i am currently
using one and its working fine.

Thanks.