Synthetic Key Issue

Fri, 15 Jun 2012 08:59:11 GMT

Hi,

I am pretty new to QlikView and its my first work. I am facing a issue with synthetic keys. I will expalin the details.

I have the following tables

1. Store Table (Master Table)

2. Drivers Table(Master Table)

3. Agents Table(Master Table)

4. Pick Table

5. Process Table

6. Grade Table

7. Customer Table (Master Table)

8. SalesDetails Table

9. ArTable

10. Trailer Table (Master Table)

11. Group Table (Master Table)

Most of the transaction tables containing more than 20 crores of data.

I have attached the relation as a image.

For the simplicity of work i created each transaction table as a qv file. But now the client need it as a single file.

When i tried to connect them a lot of synthetic keys are generated and qlikview hangs. I need to avoid the synthetic key and maintain the relation, because each transaction tables are connected and there are a lot of comparisons are taking place between them.

I would be thankful if anyone can solve this issue.. Please reply ASAP.

Thanks in Advance..

Re: Synthetic Key Issue

Fri, 15 Jun 2012 09:12:24 GMT

hi ,

you can remove the synthetic key by Aliasing the fields name using "as".

First concatinate the Transcational tables Pickup,Process and Grade Table and then u can link the Store ,agent , driver and trailer tables to them.

Similarly Concatinate the Sales and Ar table then link the customer Noand Grading to this concatinated table.

Re: Synthetic Key Issue

Fri, 15 Jun 2012 09:29:52 GMT

Thanks, I will try with that

topic Re: Synthetic Key Issue in QlikView

Synthetic Key Issue

Re: Synthetic Key Issue

Re: Synthetic Key Issue