topic Target % Expression help in QlikView

Target % Expression help

Thu, 20 Feb 2014 10:28:08 GMT

Hello,

I am looking to use a text box to show the % achieved for sales against target. What I have tried for far is =(TARGET/SALES)*100, =sum(TARGET/SALES) and =sum(TARGET/SALES)*100 to see if this would work and it doesn't (surprise surprise)! It either returns a - or a large number.

Can someone advise the best way getting this to show the decimal % or the %?

Thanks

Re: Target % Expression help

Thu, 20 Feb 2014 10:32:30 GMT

Hi Sara, try this

=Num(Sum(TARGET)/Sum(SALES),'#,##0%')

and if you want 2 decimal places then =Num(Sum(TARGET)/Sum(SALES),'#,###.##%')

Where Num() function is used to format the individual summed up values for TARGET and SALES.

Re: Target % Expression help

alexandros17 — Thu, 20 Feb 2014 10:33:08 GMT

To format a number as % you need:

Num(myExpression,'#.##0,00%')

but this is only the final part of the problem,

I don't know how your data work but try these expressions in your text box and then combine:

SUM(Target) and Sum(Sales) if they work try

SUM(Target) / Sum(Sales)

let me know

Re: Target % Expression help

Thu, 20 Feb 2014 10:36:11 GMT

Subodh Roche, worked a treat! Thank you!