Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

My Data Table: How do I link the date.

Hello, please check out my datastructure.

export.png

I want to use the 'Datum' table with the dates also for StockDetails. How can I use the datum table for both tables?

MonthlyStockFinal contains a summary of the StockDetails for the end of each month. in StockDetails the StockDate field contains the date.

1 Solution

Accepted Solutions
Not applicable

Re: My Data Table: How do I link the date.

You can create a new fıeld with "date+keypart"  in both stockdetails and monthlystokdinal tables.

3 Replies
Not applicable

Re: My Data Table: How do I link the date.

Hi

In ur stockdetails table create "Date" field

Then stockDetails table directly link to Datum table.

see below..........

StockDetails:

Load

..

..

KeyPart As %KeyPart,

StockDate

StockDate as Date

From.....

MonthlyStockFinal:

Load

Date As %date,

KeyPart As %KeyPart,

KeyPart,

EndOfMonthStock

From....

Not applicable

Re: My Data Table: How do I link the date.

I tried this but I get Syn keys. Because of KeyPart

Not applicable

Re: My Data Table: How do I link the date.

You can create a new fıeld with "date+keypart"  in both stockdetails and monthlystokdinal tables.

Community Browser