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

Calendar: Start Date, End Date & everything in between

ciaran_mcgowan — Mon, 20 Oct 2014 10:46:11 GMT

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?

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

Gysbert_Wassenaar — Tue, 21 Oct 2014 11:08:06 GMT

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

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

Anonymous — Tue, 21 Oct 2014 11:29:11 GMT

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)