topic Calculating the difference. in QlikView

Calculating the difference.

Tue, 05 Jun 2012 10:25:58 GMT

hi.

I got two seperate text boxes and i basically want to calculate the difference between the two in one text box, how could i go about doing this?

=num(sum({$<Year = {2010}>}Sales),'R#,##0'), (text box 1)

=num(sum({$<Year = {2011}>}Sales),'R#,##0') (text box 2)

Thanks.

Tue, 05 Jun 2012 10:30:47 GMT

Try this:

num(sum({$<Year = {2011}>}Sales)-sum({$<Year = {2010}>}Sales),'R#,##0')

Tue, 05 Jun 2012 13:48:15 GMT

Thanks it work. One more thing, uhm if i wanted the answer in a % form, how would i go on about that?

Tue, 05 Jun 2012 13:54:28 GMT

For example if we want the sales of 2011 related to 2010:

num(sum({$<Year = {2011}>}Sales)/sum({$<Year = {2010}>}Sales)-1,'0,00%')