Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
OndraVojtech
Contributor
Contributor

Date picker for two dates

Hi,

I curentlly have two tables, which both contains some measurements and date this measurement was measured.
Also these tables are connected via STATION (key).

I need for the Date Picker, to affect both of the DATE fields. Either this solution, or combine these two dates to one and apply date picker to this field.

Example of my problem:

MEASURE1:
LOAD * INLINE [
Station_id,Date,measure1
1,2022-10-23,10
2,2022-10-22,20
3,2022-10-21,100
];

MEASURE2:
LOAD * INLINE [
Station_id,Datum,measure2
1,2022-10-22,3
2,2022-10-22,4
3,2022-10-22,4
];

 

Note: currently the dates are named diffrently. 

Thank you for any help,
BR Vojtěch

 

Labels (3)
1 Reply
Mario_De_Felipe
Luminary
Luminary

This is a classic problem with temporal dimensions. You have several approaches, from using a master calendar to use a unique fact table:

https://community.qlik.com/qlik-blogpost/2730

https://community.qlik.com/message/283501