topic Re: data modeling in QlikView

data modeling

Mon, 28 Jan 2013 13:59:24 GMT

Dear Friends,

I have Following Issue That is

Transaction Table1:

SubAccount&Product Code as Key

Sub Account,

Company Name,

Product Code,

Date

Transaction Table 2:

SubAccount&Company as Key

Sub Account,

Company Name,

Date

Master:

Sub Account,

Company Name,

Product Code

How do I build Link and Comman calender

Re: data modeling

RedSky001 — Mon, 28 Jan 2013 14:50:06 GMT

Your data model looks wrong.

Please provide some sample real life data in the form of a script with inline statements if you'd like further assistance.

Re: data modeling

Mon, 28 Jan 2013 16:53:57 GMT

hai

Thease are Fields Common Fields Avaliable so how i can go in this case

Re: data modeling

RedSky001 — Mon, 28 Jan 2013 17:00:50 GMT

As I wrote in my previous reply

Please provide some sample real life data in the form of a script with inline statements if you'd like further assistance.

Re: data modeling

shree909 — Mon, 28 Jan 2013 17:03:33 GMT

try this

Transaction Table1:

//SubAccount&Product Code as Key

Sub Account,

Company Name,

Product Code,

Date

Transaction Table 2:

join(Transaction Table1)

//SubAccount&Company as Key

Sub Account,

Company Name,

Date

Master:

join(Transaction Table1)

Sub Account,

Company Name,

Product Code

then u will get one table with all the values which would be an outer join..

if u provide some examples it will help us

Re: data modeling

Mon, 28 Jan 2013 17:28:15 GMT

this is ok but how i can create common calender

there is no common key in transaction