Discussion Board for collaboration on QlikView Scripting.
Hello, please check out my datastructure.
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.
Go to Solution.
You can create a new fıeld with "date+keypart" in both stockdetails and monthlystokdinal tables.
In ur stockdetails table create "Date" field
Then stockDetails table directly link to Datum table.
KeyPart As %KeyPart,
StockDate as Date
Date As %date,
I tried this but I get Syn keys. Because of KeyPart