topic Can i combine two dimension together? in QlikView

Can i combine two dimension together?

Fri, 28 Jun 2013 02:36:08 GMT

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

Re: Can i combine two dimension together?

Fri, 28 Jun 2013 04:56:53 GMT

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

Re: Can i combine two dimension together?

narender123 — Fri, 28 Jun 2013 05:05:04 GMT

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

Re: Can i combine two dimension together?

Fri, 28 Jun 2013 05:35:55 GMT

can i do without editing the script?

Re: Can i combine two dimension together?

narender123 — Fri, 28 Jun 2013 05:45:46 GMT

Yes,

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

Thanks.

Re: Can i combine two dimension together?

Fri, 28 Jun 2013 05:50:43 GMT

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

Re: Can i combine two dimension together?

Fri, 28 Jun 2013 05:57:47 GMT

Take Dimension Like...

Dimension1 & Dimension2

Re: Can i combine two dimension together?

nizamsha — Fri, 28 Jun 2013 06:02:04 GMT

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

Re: Can i combine two dimension together?

narender123 — Fri, 28 Jun 2013 06:08:07 GMT

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 as key

from rableabc;

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

Thanks.

Re: Can i combine two dimension together?

Fri, 28 Jun 2013 06:08:15 GMT

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.

Re: Can i combine two dimension together?

Fri, 28 Jun 2013 06:10:26 GMT

Kindly click on the url below to be specific on what i want to get.
http://community.qlik.com/message/361906#361906

Re: Can i combine two dimension together?

preminqlik — Fri, 28 Jun 2013 09:14:39 GMT

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 ''-''