topic Re: Calc Dimension Help in QlikView

Calc Dimension Help

pgalvezt — Mon, 25 Jun 2012 16:38:04 GMT

Hello, I would like to show in 1 Pivote Table as follows:

Emp Value

a 1000

Another Name (b,c Together) 5000

d 6000

The idea is join and sum b and c and show them with another name.

I have Attached a Ex File.

Thank you.

Re: Calc Dimension Help

swuehl — Mon, 25 Jun 2012 16:47:51 GMT

You can use a calculated dimension

=if(Emp='b' or Emp='c', 'Other Name', Emp)

or even create a new field in the load script

LOAD

Emp,

Val,

if(Emp='b' or Emp='c', 'Other Name', Emp) as EmpPivotDim

FROM...

Re: Calc Dimension Help

john_duffy — Mon, 25 Jun 2012 16:48:51 GMT

Hello.

I'm not sure if I fully understand the issue.

Calc Dim.: if(match(Emp,'b','c'),'b and c',Emp)

Exp: Sum(Val)

John.

Re: Calc Dimension Help

Mon, 25 Jun 2012 16:49:08 GMT

Perhaps this in your loadscript?

LOAD
if(Emp='b' or Emp='c','anotherName',Emp) as newDimension,

* inline

[Emp, Val,
a,1000,
b,2000,
c,3000
d,6000];

See attached. Hope it helps...

(the same logic can also be applied to a calculated dimension, but I prefer fixing this in the loadscript for performance reasons on the frond-end side)

Re: Calc Dimension Help

pgalvezt — Mon, 25 Jun 2012 18:33:42 GMT

I forgot, I had to take off the 'a' so:

Emp Value

Another Name (b,c Together) 5000

d 6000

Thanks.

Re: Calc Dimension Help

swuehl — Mon, 25 Jun 2012 18:50:45 GMT

To group b and c together and take off a, try this as calculated dimension (or similar in the script):

=if(Emp = 'b' or Emp = 'c','Other Name',if(Emp <>'a',Emp))

and check 'Suppress When Value is NULL' in dimension tab.