Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ciaran_mcgowan
Partner - Creator III
Partner - Creator III

Calendar: Start Date, End Date & everything in between

Hi all,

I'm looking to create a calendar that will display all active employees in a company for the date selected. The only fields I have to work with is the Start_Date & End_Date in the Employee table. I want to create a calendar object where if I select a day it will show me all employees where:

Start_Date <= selected date <= End_Date

Is that just a matter of setting min date as the Start_Date and the max date as End_Date in the master calendar script? Or do I need to create a variable?

Can anyone help?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See this blog post for the answer: Creating Reference Dates for Intervals


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See this blog post for the answer: Creating Reference Dates for Intervals


talk is cheap, supply exceeds demand
karthigayan
Creator II
Creator II

I prefer to use 2 seperate variables. one for Start Date and another for End Date and Do the comparison of the dates in the expressions using set analysis

Sum({<selected_date={'>= $(vStartDate) <=$(vEndDate)'}>}Measurename)