Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Table:
load date1 as date
from table1;
concatenate(Table)
load date2 as date
from table2;
concatenate(Table)
load date3 as date
from table3;
Refer this blog
https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578
hi, this doesn't seem to work
We would need more information in order to be available to help you. Maybe a sample app will do the trick.
Hi,
I am renaming all fields with the same but then Synthetic keys are created.
I have the following tables:
Table1:
Load
ID
,Date
,Month//Month is created before from date and it has this format: 2022 03
,Column1
,Column 2
FROM qvd1
Load
ID
,Date
,Month
,ColumnA
,ColumnB
FROM qvd2
Table3:
LOAD
ID_2
,Date
,Month
,ColumnX
,ColumnY
FROM qvd3
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