link table

[qv_testing]

Hi Community,

PFA,

i have a requirement,

in my tables these are my common field

BRANCH, SERVICE_CENTER and SAMPLE_MONTH

how to create linktable.

Thanks in Advance

[Anonymous]

Hi,

I can see you joined all tables with FILE_NO in your model,

are these field values(BRANCH, SERVICE_CENTER and SAMPLE_MONTH) same across all tables for each of File_NO? If so why don't you keep these fields in DatabaseData table and comment out these from rest of the tables.

Can you

Thanks,

JaswantC.

[Anonymous]

Hi

I would concatenate all the Fact Tables into a single Fact Table whilst renaming the variants on the field names BRANCH, SERVICE_CENTER and SAMPLE_MONTH, so that they are all the same and associate accordingly.

Indeed it looks as if all the tables are Fact Tables so you will end up with just one table and so no joins in your Data Model.

Before I got into concatenating such Fact Tables my knee jerk was against it but now I am a convert to it.  I remember hic wrote a Blog Post about this some while back that I cannot find it, if anyone can find it and post a link to it I would be most grateful as he explains the pro's & con's of it far than I ever would.

Best Regards,     Bill

[qv_testing]

Hi Jaswant,

thanks for reply, i am new to QLIKVIEW

but i want create TimeDimension (this is my date field SAMPLE_MONTH)

i want to create a starschema model

[Anonymous]

If you are familiar with SUB functions you can CALL the Link table SUB that is included in this script library below.

qlikview-components - A script library for Qlikview development - Google Project Hosting

[qv_testing]

Hi All,

I am confusing with LINK TABLE ,,

please any one can help me..

[tresesco]

If you really want to learm and implement then please refer the attachment. Otherwise, if you are thinking of getting rid of your present model, I would give you one(there could be more) hint of issue area rather than going through the entire model of yours and correct it. Your LinkTableTemp  and the LinkTable  are having same fields and getting autoconcatenated. Hence, when you drop the temp file the link table is getting dropped with the temp file.

[qv_testing]

Hi Tresesco,

thanks for quick response..

Here i concatenate BRANCH  &'-'& SERVICE_CENTER  &'-'&  SAMPLE_MONTH as Key

SAMPLE_MONTH  is my date field,

i want to create a Year and Month

[Anonymous]

Hi,

Could you test if this is what you want :

=Year(C_SAMPLE_MONTH)

=Month(C_SAMPLE_MONTH)

You can puth it in the load-script or in any expression.

Paul

[qv_testing]

Hi Tresesco,

is it possible to create StarSchema....