topic Re: Adding % symbol after calculated value in expression in QlikView

Adding % symbol after calculated value in expression

Mon, 03 Feb 2014 10:02:05 GMT

Hi,

We have calculated value by using one IF expression lets say the valu is xyz and we just need to add '%'
symbol after that value like xyz% but when we try to use &'%' in then statement of IF condition it doesnt work. Kindly suggest alternatives.

Re: Adding % symbol after calculated value in expression

juleshartley — Mon, 03 Feb 2014 10:11:01 GMT

Hi,

Are these numeric values? If so then you may need to convert to text in order to add % to some of them. Try this:

text(xyz) & '%'

Re: Adding % symbol after calculated value in expression

juleshartley — Mon, 03 Feb 2014 10:11:48 GMT

PS: If they are numeric fields, then I'd always recommend handling the formatting in the front end and retaining the data as a decimal...

Re: Adding % symbol after calculated value in expression

Mon, 03 Feb 2014 10:11:51 GMT

yes value is numeric

Re: Adding % symbol after calculated value in expression

juleshartley — Mon, 03 Feb 2014 10:16:25 GMT

So where are you doing this formatting? You should be able to use something like this in an expression:

If ([field]= 123, num([field], '##%'), num([field], '##'))

Re: Adding % symbol after calculated value in expression

Mon, 03 Feb 2014 10:40:28 GMT

Sorry but its not working, If I append this before the value its working, like

if ([field] = 123, '%'&(sum(amount)*100) , '')-- its working

but

if ([field] = 123, (sum(amount)*100) &'%', '') -- this is not working

Re: Adding % symbol after calculated value in expression

MK_QSL — Mon, 03 Feb 2014 10:42:15 GMT

Try this ...

IF(field = 123, SUM(amount)*100) & '%'

Re: Adding % symbol after calculated value in expression

Mon, 03 Feb 2014 10:45:01 GMT

No I cant use this as I ma using big nested if

Re: Adding % symbol after calculated value in expression

MK_QSL — Mon, 03 Feb 2014 10:52:47 GMT

Remove *100 from expression and use below...

NUM(

Your Big Expression i.e. Nested If

,'#,##0%')

Re: Adding % symbol after calculated value in expression

christian77 — Mon, 03 Feb 2014 10:54:51 GMT

Hi.

Formating it's only a view. It keeps numbers in memory as they are, but it represent them with a format.

The best thing to do about it is to copy formats from the tab Number in objects or in document properties.

luck