topic Ignore dimension in calculation in QlikView

Ignore dimension in calculation

Thu, 28 Jul 2011 23:14:53 GMT

I need to ignore dimension in my calculation. So for exampe, I have location as my dimension... for location A, i want to be able to create a measure for location A in one column and location B in another column to be able to compare the two side by side. Any ideas on how I would build an expression for location B on the line for location A?

Ignore dimension in calculation

johnw — Thu, 28 Jul 2011 23:23:48 GMT

sum({<Location={'B'}>} Measure)

But I'm betting your real requirement is more complicated than that.

Ignore dimension in calculation

Fri, 29 Jul 2011 15:44:30 GMT

I tried to specify the location as you did above, but that doesn't seem to be working. It may be due to how the data is setup though.

Ignore dimension in calculation

Fri, 29 Jul 2011 16:18:13 GMT

You need a Total in there to get out of the dimension.

sum({<Location={'B'}>} Total Measure)

Ignore dimension in calculation

Fri, 29 Jul 2011 17:50:35 GMT

That did get a number to return, but it was the total for everything within that location. Now, let me add another level of complexity... I have a second dimension of state, so I want the measure for location B, but only within the state on that line item. I tried the following:

sum({<Location={'B'}>} Total <state> Measure), but no results returned for that. Any ideas?

Re: Ignore dimension in calculation

Mon, 01 Aug 2011 11:35:25 GMT

try using the function dimensionality ( ) ....it should work....

Ignore dimension in calculation

SunilChauhan — Mon, 01 Aug 2011 11:48:27 GMT

i believe it simple like i understand

sum(total <State> if(Location='B',Measure))

sum(total <state>if(Location='A',Measure))

thanks

Sunil Chauhan

Ignore dimension in calculation

Mon, 01 Aug 2011 11:59:33 GMT

I think dimensionality() func. is better if u have to ignore a particular dimension in any calculation in a pivot or a straight table.

thnxs

vivek

Ignore dimension in calculation

Tue, 02 Aug 2011 15:31:56 GMT

I had to use some trickery, but I finally got this to work. Thanks everyone for your help!