Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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/