topic Sync dates in qliksense in App Development

Sync dates in qliksense

Aspiring_Developer — Mon, 16 May 2022 10:44:32 GMT

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

Re: Sync dates in qliksense

vinieme12 — Tue, 17 May 2022 03:32:57 GMT

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;

Re: Sync dates in qliksense

Aspiring_Developer — Tue, 17 May 2022 07:34:12 GMT

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

Re: Sync dates in qliksense

vinieme12 — Tue, 17 May 2022 07:40:58 GMT

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/