topic Re: Link 2 fields in QlikView

Link 2 fields

Tue, 26 Aug 2014 04:33:49 GMT

Hello,

I have 1 field with values as

Fld1 ->

aaa

bbb

ccc

Now I want to create another field Fld2

which should have data as

Fld2 ->

ALL

aaa

bbb

ccc

Now I have to join these 2 fields. so that I do selection in fld2 it show corresponding data in fld1 as:

Fld2 -> Fld1

ALL -> aaa

bbb

ccc

aaa -> aaa

bbb -> bbb

ccc -> ccc

I have a script for it as,

LOAD * Inline [

Fld1, Fld2

aaa, ALL

bbb, ALL

ccc, ALL

aaa, aaa

bbb, bbb,

ccc, ccc ];

but need to know is there any other good solution.

Re: Link 2 fields

tresB — Tue, 26 Aug 2014 04:53:44 GMT

Yes, you have to create a generic key which you can using join(perhaps you are already doing so). See: Generic keys

Re: Link 2 fields

Tue, 26 Aug 2014 06:02:53 GMT

Hi Rupali

you can use Generic Key, this will be used for join.

Generic Keys is a way to define keys between tables in a more general way, so that their values can represent other things than individual key values; they can represent groups of key values or any key value. As an example, you can combine Field 1, Field 2 IDs.

You can use generic keys to solve many data modeling problems

1. Authorization table with OR-logic between fields

2. Mixed dimensional granularity in a single fact table

3. Multiple fact tables linked using a master link table