topic Re: Help with Text String to display % and two decimal places in QlikView

Help with Text String to display % and two decimal places

Thu, 20 Aug 2015 11:21:14 GMT

Please assist with Text String. I need this text object to display value as % with only 2 decimal places.

='Growth%: ' & (100*(Sum(Sales14)/Sum(Sales13)-1))

Can someone assist?

sunny_talwar — Thu, 20 Aug 2015 12:14:20 GMT

Try this:

='Growth%: ' & Num(Sum(Sales14)/(Sum(Sales13)-1)*100, '#.00%')

='Growth%: ' & Num((Sum(Sales14)/Sum(Sales13)-1)*100, '#.00%')

='Growth%: ' & Num((Sum(Sales14)/Sum(Sales13)-1), '#.00%')

maxgro — Thu, 20 Aug 2015 12:46:28 GMT

='Growth%: ' & num(Sum(Sales14)/Sum(Sales13)-1, '#.##0,00%')

maybe you have to change .,

- when you have an expression

Sum(Sales14)/Sum(Sales13)-1

and want to format (in a textbox)

- add num to your expression for formatting

num(expression, 'format')

and choose the format in number tab (chart or listbox)

num(expression, '#.##0,00%')

sasiparupudi1 — Thu, 20 Aug 2015 13:05:05 GMT

='Growth%: ' & num(Sum(Sales14)/Sum(Sales13)-1) , '#.##%')

qlikviewwizard — Thu, 20 Aug 2015 13:53:53 GMT

Hi,

Please use this:

='Growth%: ' & Num((100*(Sum(Sales14)/Sum(Sales13)-1)),'###,##.00')

Fri, 21 Aug 2015 06:32:10 GMT

Thanks Sunny, very helpful. I also dropped the *100 after getting the Expression OK.

Appreciate the help and this forums will go a long way to upping my skills.

Thanks all

mohammadkhatimi — Fri, 21 Aug 2015 06:44:38 GMT

Hie..

='Growth%: ' & num(Sum(Sales14)/Sum(Sales13)-1) , '#.#0%')

do it from

Properties-> Number tab->Fixed to(How much digit you want) and check the Show in percentage checkbox...

Hope this will helps you..!!

Regards,

Mohammad