hi, I have 4 tables with nothing in common(no IDs shared), but all 4 tables have the same date field - Date.
I want to load all data from the 4 tables and use for different charts, but I need to have only one date column to filter in the app - so when I chose 2022-01-01 as filter I see data for that date in all charts
If I load all tables and keep the same Date name for the date column, I create synthetical keys and that is not ok.
How can I load all data and keep only one Date field in Qliksense interface?(user doesn't want to see all the Date columns from all 4 sources and I need only one Date column that works for all charts)
thank you