Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oanalung
Contributor III
Contributor III

Qliksense Date filter

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? 

5 Replies
danielrozental
Master II
Master II

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;

 

vinieme12
Champion III
Champion III

Refer this blog 

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
oanalung
Contributor III
Contributor III
Author

hi, this doesn't seem to work

danielrozental
Master II
Master II

We would need more information in order to be available to help you. Maybe a sample app will do the trick.

oanalung
Contributor III
Contributor III
Author

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