% difference Sales vs Targets

[#1]

Hi,

How can i calculate Actual Sales vs Target 2016 (i.e  percentage difference)?

My column names in excel are: Total Sales and Total Target 2016.

I already have a bar chart on Qlik Sense which compares the sales rep performance  but i would like it to show in the same column the difference in %. (whether that's a growth or decrease)

Alex

[Gysbert_Wassenaar · Accepted solution]

Usually it's something like =num(sum([Actual Sales])/sum([Target 2016]) -1,'0.00%')

[satishkurra]

Hi

You can also use the Gysbert Wassenaar's expression by adding symbols,

For Increase it shows up and for Decrease it shows down symbol.

Like this:

Num(Sum([Actual Sales])/Sum([Target 2016])-1, '▲ 0.0%;▼ 0.0%')

[#4]

Thank you Satish.

How do i make the adding symbol and where do i write that expression?

Are there any other calculations you are aware of that will make my project shine?

[satishkurra]

Refer the attached app

Thanks

[#6]

Satish,

I've used the expression and works great.

Num(Sum([Actual Sales])/Sum([Target 2016])-1, '▲ 0.0%;▼ 0.0%')

How can I put a red color when their targets are below 0%

[#7]

Thank you,

I've used the expression, since I wanted to include an indicator as well and it's in the master file in measures:

Num(Sum([Actual Sales])/Sum([Target 2016])-1, '▲ 0.0%;▼ 0.0%')

How can I add red color if its negative and green color if its positive.

Alex

[Gysbert_Wassenaar]

You can use the Text color expression setting of the measure. See the image below for an example":