Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can i combine two dimension together?

Is there any way that i can combine two dimension and caluculate together in dimension?

1 Solution

Accepted Solutions
preminqlik
Specialist II
Specialist II

Another Method i mean in UI also u can implement this just by at the stage of selecting dimensions just click on Add Calculated dimension and do following

fieldname1&'seperator&fileldname2

for example : Branch&'-'&SalesPerson

here the separator is ''-''

View solution in original post

11 Replies
Not applicable
Author

Try this...

Example::::::::::

RawData:LOAD * INLINE [
Doc ID, Name, Marks
112, a, 21
112, b, 22
134, c, 34
135, d, 33
135, a, 44

]
;

Data:LOAD [Doc ID],
Name,
[Doc ID]&'-'& Name As Doc_Key,
 
Marks
 
 
Resident RawData;
 
DROP Table RawData;

Take a chart..Dimension : Doc_Key

Exp : Sum(Marks)

Regards-Bika

narender123
Specialist
Specialist

Hi,

Simply by making that dimention composite key.

like.

your 1st dimention that you want to combine is    a

your 2nd dimention  that you want to combine is  b

then in  load statement

Load

a &'-'& b as Key,

....

....

from tableabc;

Thanks.

Narender

Not applicable
Author

can i do without editing the script?

narender123
Specialist
Specialist

Yes,

Yes for  this you can do in script under load statement.

Thanks.

Not applicable
Author

Hmm..i think you misunderstand what i meant. I meant can i combine two dimension WITHOUT editing the script. Is there any way?

Not applicable
Author

Take Dimension Like...

Dimension1 & Dimension2

nizamsha
Specialist II
Specialist II

if u want to use two dimension mean and also u want to see the data in each dimension wise mean use

cyclic or drill down group or else combine the 2 field using and like this a '&' b as key  in script

narender123
Specialist
Specialist

Sorry dear by mistake i didnt get you.

You can do it only with script.

if you used cylic grioup or drill down yet you see the dimention seperately.

Alternative is that like

load

a,

b,

c,

a &'-'& b as key

from rableabc;

By this your both a and b will combine as kay also a and b are seperately like past.

Thanks.

Not applicable
Author

if((Group_Discharge <=40)<=(Group_Load<=40), Group_Load & ' <-> ' & Group_Discharge )

This is the code i'm using.

I need to combine two dimension and sum the data together to become only one column. Hope you all got what i mean.