Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys! I have some problems with creating an expression which shows information about the annual sales growth. I want to make this for 2013 and 2012 but I have some problems in making the formula. I know that it have to be something like this:
SUM([2013 sales])
/
SUM([2012 sales])
-
1
I've already have expressions which shows the sales for 2012 and 2013 which are made with if statement. I just don't know how to write them in this case.
Thank you in advance for your help guys!
Hi
Assuming that you have calculated field for sale 201`2 and sales 2013, you can try something like below.
((SUM([2013 sales])-SUM([2012 sales]))
/
(SUM([2012 sales])))*100
Regards
ASHFAQ
num((Sum(Sales2013)-Sum(Sales2012))/Sum(Sales2012),'##.00%')
Actually I am not sure how to make these in calculated fields. I've got 2013 and 2012 sales in two different charts. Sorry for the question but I am new QlikView user.
Hi,
If possible can you post your qvw file here.
Regards
ASHFAQ
I can, but I am using the personal edition and I won't be able to open the file after that. I need that file because I am going to use it on my final exam at the university on Wednesday.
Hi,
Just attach file.
I will guide you how to fix that in your file.
Regards
ASHFAQ