topic How can I use calculated dimension in difference calculation in QlikView

How can I use calculated dimension in difference calculation

saaskve1 — Thu, 26 May 2011 12:28:07 GMT

Hello,

I am having problems with calculated dimension.

I would like to calculate variance for different data versions as shown in really simple example below...

Dimension is Version and Expression definitions are in below.

So, how should I calculate the variance for Versions?

Expressions		Actual	Budget	Variance
=sum({$<Version = {'Actual','Budget'}>}Sales)	Sales	500	450	50
=sum({$<Version = {'Actual','Budget'}>}Costs)	Costs	358	330	28
=((column(1)-Column(2))/Column(1)	Margin%	28%	27%	2%

Data model is like below:

saaskve1 — Tue, 31 May 2011 07:07:51 GMT

Hi,

Does anyone have any ideas?

It would also be helpful information to know if it can't be done so I could try something else...

christian77 — Tue, 31 May 2011 07:17:54 GMT

Calculated dimensions don´t take functions like sum, avg, etc. They only allow ifs. Do your calculations on the script.

Also, I think some people are confusing variance and variation. They are two different things.

Ok.

saaskve1 — Tue, 31 May 2011 07:41:55 GMT

Thanks.

I will try another approach.