topic Re: Calculate Difference column in QlikView

Calculate Difference column

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

Next example

First column year with totals pro week for years 2014 and 2013

2014 2013

52 100 150

51 200 200

50 300 600

49 400 350

Now i want to add 2 columns pro year.

First column shows me the difference amount. Column next to it shows me the percentage growth / lost toward previous year.

2014 2013

52 100 -50 33,33% 150

51 200 +0 0% 200

50 300 -300 -50% 600

49 400 +50 14% 350

How to do this?

Re: Calculate Difference column

sushil353 — Thu, 16 Oct 2014 09:41:48 GMT

Hi,

Find attached.

HTH

sushil

Re: Calculate Difference column

Thu, 16 Oct 2014 11:13:56 GMT

Hi,

Can't find attachment

Re: Calculate Difference column

Fri, 17 Oct 2014 07:34:21 GMT

Attention to Orginal Question

Who helps me?
Thx in forward.

Re: Calculate Difference column

Fri, 17 Oct 2014 09:49:30 GMT

Hello,

Big Challenge. Does nobody knows the answer?

Re: Calculate Difference column

Fri, 17 Oct 2014 11:05:20 GMT

Attached is the solution

Ivelin

Re: Calculate Difference column

Fri, 17 Oct 2014 11:41:45 GMT

Thx, but excuses me I am new.

I do not know what you mean. can you explain me more?

Thx in advance

Re: Calculate Difference column

Thu, 30 Oct 2014 10:42:23 GMT

Hello,

Who can help me and explain how attaced is being used?

Re: Calculate Difference column

suresh_rawat — Thu, 30 Oct 2014 10:51:01 GMT

Hi,

I will Explain You abou the attached file above.

1 ) For Getting 2013 Sales the expression is : Sum({<Year = {'2013'}>} totals)

2 ) For Getting 2014 Sales the expression is :Sum({<Year = {'2014'}>} totals)

Then you Want 3 Expression in the Difference

3 ) Add Expression and Name it Difference : Sum({<Year = {'2014'}>} totals) - Sum({<Year = {'2013'}>} totals) - Use this Expression.

Then you Want 4 Expression in the Difference in Percentage

Use This Expression : (Sum({<Year = {'2014'}>} totals) - Sum({<Year = {'2013'}>} totals))/ Sum({<Year = {'2013'}>} totals)

Hope you understand this.

Regards

Suresh Rawat

Re: Calculate Difference column

Thu, 30 Oct 2014 12:15:27 GMT

thx! But instead of Year i have to take yearweeknr?! I shall try this later.

Re: Calculate Difference column

Thu, 30 Oct 2014 20:27:28 GMT

Everybody , but it won't succeed.