topic Re: How to optimize this model in QlikView

How to optimize this model

Tue, 02 Apr 2013 15:31:23 GMT

I have a three tables with the follwoing charesterics 1. Some attributes are common on all table or in two tables. 2. Having common date filelds and some unique date fields. Im having difficulty in modeling how to combine the common fields.

I'm trying to achive 1. Avoid SYNC table and 2. Create a master calender combining all date fields (common or unique files) .

Thanks for your help.

Re: How to optimize this model

pauljohansson — Tue, 02 Apr 2013 15:41:50 GMT

Hi,

From a technical standpoint you can simply make sure that the link between your table consists of only one field. But i would recommend by asking yourself how you want your sheets to relate to each other. What do you want to achieve?

Regarding dates. You have several date columns, ask yourself which one of them you want to be the link to your Master calender table.

br Paul

Re: How to optimize this model

Tue, 02 Apr 2013 15:54:42 GMT

Can you specify which of the fields are comman among the three tables.and which are unique

Re: How to optimize this model

Tue, 02 Apr 2013 16:10:04 GMT

Common between [WIN 8 OS Updates] and JET campain tables

TOEM,

[Code Name],

Date(LeadExit, 'MM/DD/YYYY') as LeadExit,

Date(TestApprove, 'MM/DD/YYYY') as TestApprove,

Date([Availability Date],'MM/DD/YYYY') as Availability_Date,

Active,

Devices_Updated,

[Update Mechanism] AS Platform,

Size_MB,

in Sum_2012 there are the common fileds with above

TOEM,

[Code Name],

Pushed AS Devices_Pushed,

Updated AS Devices_Updated,

Platform,

Size_MB,

Im having difficulty in link all dates (common and unique) to a master tables. Let me know if im thinking wrong. Please let me know if you have any questions.

Re: How to optimize this model

Tue, 02 Apr 2013 16:23:52 GMT

See there are three different reports on same business unit and trying to build a demo presentation using qlikview. Im sure they will ask me to add 7 more to this one after the demo.

Since i have multiple dates, some of them are in common and some don�t.

If i look at your questions: Yes. I will build 2 different sheet one for each table. I want to link most of the date fields to master calender, so i can show the data from multiple ways (dates). Please let me know if you have any questions.

Re: How to optimize this model

Tue, 02 Apr 2013 16:44:54 GMT

Concatenate the common fields of the three sheets onto one master table and use [Code name] as the foreign key. The dates which arent common need to have different names.

Re: How to optimize this model

Tue, 02 Apr 2013 18:04:19 GMT

how do i link all the common and uncommon date fields to achive master calender? if i would go with your design.

Re: How to optimize this model

kamalqlik — Wed, 03 Apr 2013 09:02:45 GMT

Hi,

Can you please give me a brief explanation about the reqiurement from the User.

What are the reports requirement that the user want to show.

1)You have to alias the attribute for getting rid of synthetic keys

and please identify the Primary key that will be needede for the linking

2)Comment the fields which are not used as report prespective

3) as far as master calendar

In case you want to merge all the date fields by giving them as same attribute name and link to master calendar as per to get the appropiate results.

In case you want the result to be in base of each date field i want the user requirement so that i can help you out.

Regards

Kamal Naithani

Re: How to optimize this model

neetu_singh — Wed, 03 Apr 2013 09:17:24 GMT

Hi,

Please find the attached file, may be it helps.

For date field, create a master calender link with link table with a Date field named COMMON_DATE.

Regards

Neetu

Re: How to optimize this model

Wed, 03 Apr 2013 09:40:39 GMT

Hope its help you

Re: How to optimize this model

Sat, 04 May 2013 15:35:33 GMT

ni Neetu,

I have followed your model and i have question. In Table3, how do i connect Month field with the calender. Because i have provide a selection creteria for Month filed.

Thanks for your help.