Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ciaran_mcgowan
Not applicable

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?

Tags (3)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Calendar: Start Date, End Date & everything in between

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


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: Calendar: Start Date, End Date & everything in between

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


talk is cheap, supply exceeds demand
karthigayan
Not applicable

Re: Calendar: Start Date, End Date & everything in between

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)