topic Re: data Model issue in QlikView

data Model issue

Fri, 31 May 2013 04:46:20 GMT

I gt six tables,

hav linked thm with a common key, also i hav created a calender for linking all the respective dates

but whn i try to link it with the calender table loop gets generated,

Hw to avoid tht loop, and hw can i link all the dates thn..

Please share some suggestions, hav attached the structure of the tables in attached file,

sivarajs — Fri, 31 May 2013 04:52:44 GMT

Most of the fields are common in your table just use concatenate to avoid the loop

Fri, 31 May 2013 04:56:15 GMT

Thanks Sivaraj for responding,

but the client is interfering in the data model he wants no concatenation, wants a common calender also

let me knw some logic to solve this.

Fri, 31 May 2013 05:02:11 GMT

anybody pls respond.....

vikasmahajan — Fri, 31 May 2013 05:32:34 GMT

Hii,

You can use link tables insted of concatenate I am attaching you sample demo for the same

create keys and link table.

Hope this help you

vikas

Also request you to send all excels so that we can help you.

Fri, 31 May 2013 06:34:46 GMT

Thanks for helping, i used the same concept but not the composite primary keys,

will do with tht approach later, first will deliver the output to the user..

Thanks