topic Re: Conditional Number formatting in expressions in QlikView

Conditional Number formatting in expressions

Mon, 09 Jan 2017 20:13:56 GMT

Why doesn't this add a $ to my output? This is the only case where I need the value to be represented as a monetary result.

Here is the current result:

Re: Conditional Number formatting in expressions

girirajsinh — Mon, 09 Jan 2017 20:24:32 GMT

Try putting $ in Format code like '$#,###.00'

Re: Conditional Number formatting in expressions

johnw — Tue, 10 Jan 2017 01:15:19 GMT

I'm not sure why it doesn't add $ to your output, and I agree with Girirajsinh that the $ would be better in the format code. It'll then remain a number instead of being converted to text. But I'd probably do this instead...

sum({<Account={'Travel ODC'}>} [Cost Amount])

...and format as money on the number tab.

Re: Conditional Number formatting in expressions

Tue, 10 Jan 2017 14:08:46 GMT

Hey guys- I switched up the formatting but it's still not giving me the expected $ in the output. I currently am only showing the Travel ODC account in my formula to test this out. There are 5 other accounts, 1 of which is labor. The output from that variable is hours, not dollars. This is why I do not want to format the entire expression as money on the Number Tab.

Re: Conditional Number formatting in expressions

marcus_sommer — Tue, 10 Jan 2017 14:14:09 GMT

Like above mentioned you could simply use num() to format your wished output - it will work:

num(sum(Measure), 'hours #.##0,00')

- Marcus

Re: Conditional Number formatting in expressions

Tue, 10 Jan 2017 14:14:51 GMT

Well.. by checking the Number tab, I did find the problem. I'd overwritten the expression default to integer. I changed it back and now the suggested formatting from Girirajsinh works great.

Blonde moment I suppose...

Re: Conditional Number formatting in expressions

sunny_talwar — Tue, 10 Jan 2017 14:17:13 GMT

Please close the thread by marking correct and helpful responses

Qlik Community Tip: Marking Replies as Correct or Helpful