topic Re: Join in QlikView

Join

kmswetha — Wed, 17 Jun 2015 14:31:54 GMT

Hi,

I have a field in fact say xxx and in one dimension which has two fields YYY , ZZZ.

Now the problem is xxx will either join with YYY (or) ZZZ fields but not both.

Can some one throw their thoughts on this?

Re: Join

alexandros17 — Wed, 17 Jun 2015 14:33:38 GMT

Send a sample or explain better please

Re: Join

sunny_talwar — Wed, 17 Jun 2015 14:35:08 GMT

Providing a sample data with expected output will make it easier to understand what you are looking to do.

Best,

Sunny

Re: Join

kmswetha — Wed, 17 Jun 2015 14:58:05 GMT

HI,

This is how the data looks like in dim and fact.

Fact	Dimension
XXX	YYY	ZZZ
160	160	177
161	161	172
162	162	173
163	174	163
164	175	164

Re: Join

ramoncova06 — Wed, 17 Jun 2015 15:03:01 GMT

I think I know what you mean

Mapping

xxx:

load

xxx,

xxx

your table ;

load

yyy

zzz

if(applymap('xxx','yyy','no') <> 'no',applymap('xxx','yyy'), applymap('xxx','zzz')) as xxx

your table;

after this you can do whatever you want for joining

Re: Join

kmswetha — Wed, 17 Jun 2015 15:13:06 GMT

Hi Ramon,

I cannot apply Applymap, because XXX doesn't have an other field to look and return and also XXX field is from fact.Just thinking if Fact can be used as Mapping table as it would have huge data.

Re: Join

ramoncova06 — Wed, 17 Jun 2015 15:17:52 GMT

you can use a fact for a map, and did you see that I just used the same field twice, though you just have to rename

Mapping

xxx:

load

xxx,

xxx as 1

your table ;

Re: Join

kmswetha — Wed, 17 Jun 2015 16:20:03 GMT

Hi Ramon,

This is not working for else part.

i'e applymap('xxx','zzz')

Re: Join

ramoncova06 — Wed, 17 Jun 2015 16:46:28 GMT

sorry I just noticed that my example had the wrong quotes

applymap only needs single quotes on the first name of the mapping table so it should be something like applymap('xxx',zzz)

Re: Join

kmswetha — Thu, 18 Jun 2015 10:52:39 GMT

Hi Ramon,

I have taken care of this initially .Logically it should work, But some thing it is not working.

Re: Join

ramoncova06 — Thu, 18 Jun 2015 14:38:18 GMT

would have to see what you doing in order to be able to provide feedback