Discussion board where members can get started with Qlik Sense.
I have a master calendar that works fine with the "start_date" field that I have in a table called "event". In another table, "link", I have another date field called "link_date".
I would like that when the user filters using the master calendar, his selection affected not only to events, but to links too.
I tried to rename "link_date" as "start_date", but that provokes a loop. What's the best approach to a situation like this?
It would be sthing like this:
here's a script you can use to build a test application and understand how to handle different dates:
LOAD * INLINE [
ID, Seq, ActivityDate, Value1
1, 1, 2011-5-10,10
1, 2, 2011-5-12,2
2, 1, 2011-5-12,20
3, 1, 2011-6-15,40
LOAD recno() as ID, * INLINE [
DepartureDate, ArrivalDate, Value2
LOAD recno() as OtherID, * INLINE [
,ActivityDate as Date
,'Activity' as DateType
,DepartureDate as Date
,'Departure' as DateType
,ArrivalDate as Date
,'Arrival' as DateType
,OtherDate as Date
,'Other' as DateType
,date(monthstart(Date),'MMM YYYY') as Month
LOAD date(makedate(2011,5,1)+recno()-1) as Date
Similar to what omar has shown.
I'm in the same situation: i need to create a master calendar that allows me to drive and measure on two tables both having a date field.
Did you solve the situation?
How did you do?
I followe what is shown by Mike Tarallo on this video https://www.youtube.com/watch?v=ek_ITfvCnHw
it works fine if I link the master calendar to one table, but I'm not able to link it to two.
Actually I decided to keep both calendars separated. I'm having two different master calendars and it's working for me so far.
If down the road I'm forced to use a single one, I'll post here my findings.
Can you please post how did you solve this issue - Single calendar with multiple dates in an application
As I told Luigi, I ended up deciding to have two calendars separated. I didn't create the single one. However, maybe Omar's reply and Wallo's link may help you.