Discussion board where members can get started with Qlik Sense.
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)
Go to Solution.
Usually it's something like =num(sum([Actual Sales])/sum([Target 2016]) -1,'0.00%')
You can also use the Gysbert Wassenaar's expression by adding symbols,
For Increase it shows up and for Decrease it shows down symbol.
Num(Sum([Actual Sales])/Sum([Target 2016])-1, '▲ 0.0%;▼ 0.0%')
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?
Refer the attached app
I've used the expression and works great.
How can I put a red color when their targets are below 0%
I've used the expression, since I wanted to include an indicator as well and it's in the master file in measures:
How can I add red color if its negative and green color if its positive.
You can use the Text color expression setting of the measure. See the image below for an example":