Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to select records by StartTime and EndTime

Hi

the table have two columns  StartTime  and EndTime  ,Now I want to select  the time by calenderA and calenderB ,and the time of calenderA before StartTime     the time of  calenderB  after EndTime  ?   just like the picture搜狗截图20160310155149.png

2 Replies
its_anandrjs
Champion III
Champion III

Hi,

Read this thread for how to implement Calendar object.

Implementing From and To Date Selection using Calendar Objects

Regards

Anand

jagan
Partner - Champion III
Partner - Champion III

Hi,

Check this link for solution using variables, set analysis and calendar objects

Implementing From and To Date Selection using Calendar Objects

Regards,

Jagan.