topic Concatenate a number to a string in QlikView

Concatenate a number to a string

Mon, 26 Jul 2010 05:24:36 GMT

Hi all,

I have a Text object used to display the result of the following equaction:

= if(round(sum(Value)/sum({$<Product_Name=, Account_Name=>} TOTAL Value)*100)>0,round(sum(Value)/sum({$<Product_Name=, Account_Name=>} TOTAL Value)*100),0)

As this calculation displays percentage, I'd like to append it with the percentage sign "%". How can I do it? The following formula didn't work thogh:

= if(round(sum(Value)/sum({$<Product_Name=, Account_Name=>} TOTAL Value)*100)>0,round(sum(Value)/sum({$<Product_Name=, Account_Name=>} TOTAL Value)*100),0) $ '%'

Any suggestion is appreciated.

Concatenate a number to a string

Mon, 26 Jul 2010 05:31:49 GMT

Hi ahmedb,

Replace '$' with '&' without the quotation marks.

- Lester

Concatenate a number to a string

Oleg_Troyansky — Mon, 26 Jul 2010 05:58:08 GMT

I'd recommend formatting the number using function num:

num( ... , '#,##0.0%')

This way, not only you get the desired %-sign, but also the number will be limited to a required number of decimals and, if needed, show a thousand separator. Keep in mind that you don't need to multiply by 100 - it will be done automatically...