topic Re: Need help with an expression in QlikView

Need help with an expression

Sun, 29 Jun 2014 09:09:40 GMT

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])

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!

Re: Need help with an expression

ashfaq_haseeb — Sun, 29 Jun 2014 09:37:12 GMT

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

Re: Need help with an expression

Sun, 29 Jun 2014 10:10:30 GMT

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

Re: Need help with an expression

Sun, 29 Jun 2014 10:31:14 GMT

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.

Re: Need help with an expression

ashfaq_haseeb — Sun, 29 Jun 2014 10:36:11 GMT

Hi,

If possible can you post your qvw file here.

Regards

ASHFAQ

Re: Need help with an expression

Sun, 29 Jun 2014 10:39:55 GMT

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.

Re: Need help with an expression

ashfaq_haseeb — Sun, 29 Jun 2014 10:41:42 GMT

Hi,

Just attach file.

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

Regards

ASHFAQ