Need help with an expression

[#1]

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!

[ashfaq_haseeb]

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

[#3]

num((Sum(Sales2013)-Sum(Sales2012))/Sum(Sales2012),'##.00%')

[#4]

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.

[ashfaq_haseeb]

Hi,

If possible can you post your qvw file here.

Regards

ASHFAQ

[#6]

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.

[ashfaq_haseeb]

Hi,

Just attach file.

I will guide you how to fix that in your file.

Regards

ASHFAQ