ApplyMap() for one to many relation(Data model issue)

sibin_jacob — Sat, 29 Jun 2013 18:41:18 GMT

Hi All,

I am facing some problems in my data model. In my fact tables are multiple levels. The levels are Physician, Zip and account. But I want direct relation between Zip and account, Zip and Physician, Account and Physician.

I planned to use only one fact table. So I am using mapping load, link table and apply map functionality in the loading script. I have one
to one relation between physician and Zip. But I have one to many relations between Account to Physician and Account to zip. (one account having
multiple Zip and multiple Physician)

I created mapping table for account to physician, Account to Zip and Physician to Zip. And in dummy data I added three values for account
that are ‘ACC2’, ‘ACC3’ and ‘ACC4’. In that ‘ACC2’ and ‘ACC3’ having only one physician and Zip but ‘ACC4’ having more than one Zip and Physician.

I am getting the correct values at physician and Zip level. But I am not getting the right values and selection for ‘ACC4’ selection.

So Please help me to write the applymap() for one to many relation.

How will I write applymap() script for one to many relation?

PFA my application for your reference.

Thanks,

Sibin Jacob. C

Re: ApplyMap() for one to many relation(Data model issue)

sibin_jacob — Sat, 29 Jun 2013 18:58:46 GMT

By mistake .. I marked as Assumed...

I don't know how to unmark assumed answered.

Thanks,

Sibin Jacob

topic ApplyMap() for one to many relation(Data model issue) in QlikView

ApplyMap() for one to many relation(Data model issue)

Re: ApplyMap() for one to many relation(Data model issue)