topic Re: Issue with Datamodel in QlikView

Issue with Datamodel

amijit_hazarika — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlik Enthusiast,

I am building a datamodel and getting stuck with bringing the right data and removing synthetic keys.

I have 2 files(File A and File B) and I have created facts and dimensions out of these 2 files.

Fact has Emp Id, Enitity Id, Revenue etc and Dim has Entity Name, Geography, Function etc.

When I join these with the help of Emp Id, I don't get correct output for Entity Name.

When I join with Entity Id then I get correct data for Entity Name but not the right Employee Id gets picked up.

For testing, I joined with Emp ID and Entity ID, I am getting the right output but this leads to synthetic table.

Solution or any advice would be highly appreciated.

Thanks in Advance.

Re: Issue with Datamodel

isingh30 — Thu, 17 May 2018 13:33:57 GMT

Can you share your data or sample application?

Thanks

Re: Issue with Datamodel

YoussefBelloum — Thu, 17 May 2018 13:33:57 GMT

Hi,

on both tables, you should create a composite key, like this:

Autonumber([Emp ID]&[Entity ID]) as Key

and remove [Emp ID] and [Entity ID] fields from your tables

PS: you can create composite key without functions like Autonumber(), like this: [Emp ID]&[Entity ID] as Key

it is a matter of optimization

Re: Issue with Datamodel

amijit_hazarika — Thu, 17 May 2018 13:53:30 GMT

Hi,

Which one would you suggest? Autonumber or Autonumberhash128?

Thanks

Re: Issue with Datamodel

YoussefBelloum — Thu, 17 May 2018 13:59:41 GMT

it depends on the amount of data you load.. and on other things that I ignore.. on a small/medium set of data I put whatever comes in mind. when it comes to heavy datasets, I automatically do some benchmarking

Re: Issue with Datamodel

uroboros — Thu, 17 May 2018 14:05:55 GMT

Hi @Amijit,

Have you try rename your fields for asociate you datamodel?

For be more helpfull, could you share to us more information, one pic, or a dataset to help you!

Re: Issue with Datamodel

amijit_hazarika — Thu, 17 May 2018 15:00:41 GMT

Thanks Youssef!

This worked.

Cheers (y)

Re: Issue with Datamodel

YoussefBelloum — Thu, 17 May 2018 15:06:01 GMT

you're welcome, good luck