topic Conditional Formatting in a Text Object in QlikView

Conditional Formatting in a Text Object

Sat, 12 Dec 2009 03:20:04 GMT

First time submission.

I want to format the number in a text box to read 'LTL Revenue $12,453.60'. Using the script below returns the result as 'LTL Revenue 12453.60'. I'm open for suggestions.

Thanks

Vic

'LTL Revenue ' & Num(sum(if(OriginTerminal<950, RevenueBeforeSurcharge$,'$#.##0; ($#,##0)'

)))

Conditional Formatting in a Text Object

mike_garcia — Sat, 12 Dec 2009 03:36:03 GMT

Hello,

I can see that there are a few parenthesis missing. It might sound silly but maybe that's the issue.

Mike

Conditional Formatting in a Text Object

Sat, 12 Dec 2009 03:37:33 GMT

Hi Vic,

It seems that your thousand separator is not the same in both parts of the format string, but that will not so much difference.

Could you not use the money() function instead of num?

regards Jan

Conditional Formatting in a Text Object

prieper — Sat, 12 Dec 2009 03:47:57 GMT

Agree with Mike, parenthesis are wrong. Try with

= 'LTL Revenue ' & Num(sum(if(OriginTerminal<950, RevenueBeforeSurcharge)), '$#,##0')

Thus in the above code it will not show anything, if "OriginTerminal < 950

HTH
Peter

Conditional Formatting in a Text Object

Mon, 14 Dec 2009 19:58:54 GMT

Thanks everyone for the feedback. Mike, you and Peter were correct, it was in the location of the parenthesis. I have the results I was looking for.

Vic