topic Formatting expression for both % and Numbers in QlikView

Formatting expression for both % and Numbers

Wed, 19 Dec 2012 10:05:14 GMT

Hi,

I need to display both % values (to two decimal places) and whole numbers as a 'value' in my pivot. My current expression checks what the calculation should be :

If(single_value='N',num((sum(val1)/sum(val2)*100),'#,##0%'), sum(val3))

When I try this expression the percentage value is displayed incorrectly (5,232%, 479%)

I need to display percentages as 99.99% (to two decimal places) and full values which can run into 1000's (99,999 , 139942) also to two decimal places.

I have number format settings set to 'Expression Default' (see attached image).

Many thanks for your help,

Fiorano

Re: Formatting expression for both % and Numbers

Gysbert_Wassenaar — Wed, 19 Dec 2012 10:28:43 GMT

Try If(single_value='N',num((sum(val1)/sum(val2)),'#,###.00%'), num(sum(val3),'#,###.00'))

Re: Formatting expression for both % and Numbers

Wed, 19 Dec 2012 10:40:48 GMT

Excellent! Works perfectly!!!

Thank you very much for your time.!