topic Compare Calculation for Dimension Value Against Another Dimension Value in QlikView

Compare Calculation for Dimension Value Against Another Dimension Value

Mon, 16 May 2011 22:25:37 GMT

I am trying to compare a calcuation for the dimension value of my row against another value within the same dimension. For example, I have the dimension of locations and they have 5 locations (location a, location b, location c, location d, location e) and I want to compare the total billed amount for location a, b, c, d to that of location e so that it would look something like the below:

LOCATION	TOTAL BILLED (SELECTED LOCATION)	TOTAL BILLED (LOCATION E)
A	$100.00	$250.00
B	$275.00	$250.00
C	$75.00	$250.00
D	$325.00	$250.00

Can someone please tell me how I can accomplish this?

Thanks!

Re: Compare Calculation for Dimension Value Against Another Dimension Value

nagaiank — Mon, 16 May 2011 23:53:02 GMT

An example for accomplishing what you want to do is attached.

Hope this helps.

Compare Calculation for Dimension Value Against Another Dimension Value

Tue, 17 May 2011 01:58:59 GMT

Thank you. Your solution does exactly what I need it to do, but I can't seem to get it to work with my data structure. Will look into it some more.

Thanks again!