I have 3 tables that I am loading into Qliksense and create one visualization object for each table. In all 3 tables I have different date columns, but I want to create a date filter in Qliksense so I can see simultaneous on all 3 visualizations data for the same period.
Example: I want to see data for 2022-03-01 and I want all visualizations to contain data for that period, but only use one filter(column).
How can I achieve that?
You should rename the 3 date fields as the same field name. If more dimensions are shared you should concatenate the 3 tables.
Something like this
load date1 as date
load date2 as date
load date3 as date
I am renaming all fields with the same but then Synthetic keys are created.
I have the following tables:
,Month//Month is created before from date and it has this format: 2022 03
In the interface I want to use Date and Month as filters to work across all objects(I have multiple charts and each of them is loaded from another qvd). If I keep this load, synthetic keys are created