Sync dates in qliksense

[Aspiring_Developer]

Hello Champs,

Please help me with below scenario :-

I have below tables:-

1) Table name- EMS Master

Report date 15/05/2022

Count(open issues)—117

Sum(open wkg days)-1439

2) Table name- Trend table

No data for 15 the may

When selected report date as 14/05/2022

Count of open issues – 1439

Sum(sum open wkg days)- 117

Tables are linked via Report Date.

I wish to sync the dates in both the tables.

Right now , in first table the value for 15th may is 117 & 1439  and in the second table the value for 14th may is 117 and 1439 and there is no data for 15 th may. This is the same case for all the records. How should I sync these table in a way that it should showcase values on same set of date.

Should  I do -1 in EMS  master table ? Not sure what is the correct way ! Please help 

Thanks in advance

[vinieme12]

given both your datasets have similar structure, in terms of field & fieldvalues

You can combine both tables into one large table

FACT:

Load   *,'EMS' as Datasource from  EMSData;

CONCATENATE(FACT)

Load   *,'Trend' as Datasource from  TrendData;

[Aspiring_Developer]

Hi  

Thanks for your response.

But my data fields are not quite similar. In fact , in table 1 I have 12 data fields and in table 2 I have only 5 data fields.

Thanks

[vinieme12]

Then you can just create one calendar the associates based on Report_Date

copy the script from here and replace OrderDate with Report Date

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/