topic Re: Number Formatting Issue with ,'#,##0') in QlikView

Number Formatting Issue with ,'#,##0')

Qliksand — Fri, 19 Aug 2022 08:40:00 GMT

Hi,

I am trying to format an outcome as a percentage using ,'#,##0').

Script is:

= 'x' &'

'&
SUM (if(C = 'Y',DX))& ' '&

'('& SUM (if(C = 'Y',X))
/
SUM (if(C = 'Y',Z) ,'#,##0')

Any hints to why I would be seeing an error in expression?

Thanks!

Re: Number Formatting Issue with ,'#,##0')

Digvijay_Singh — Fri, 19 Aug 2022 13:09:01 GMT

You cannot do like this, formatting in Qlik is done using NUM() function and that is missing over here, its used something like this - Num(Sum(Value),'#,##0').

In your case the format string is not attached to any single value as well, so may be you need to do like this -

= 'x' &'

'&
SUM (if(C = 'Y',DX))& ' '&

'('& NUM(SUM (if(C = 'Y',X))
/
SUM (if(C = 'Y',Z) ,'#,##0%')

Re: Number Formatting Issue with ,'#,##0')

Qliksand — Fri, 19 Aug 2022 14:33:00 GMT

That's perfect, thank you so much!