Can I select one year from two different date fields?

[akile002]

My problem is that I have two dates. I have a Hire Date and a Termination Date. I want to be able to select one year and pull up the Hire count and Termination count. Is there a way to combine the two to be able to select one year?

[jonasheisterkam]

You can use on select trigger from on one of the fields to select the other. You find it in Document Settings Actions. Better is to connect them in data model if possible.

Can you attach a small example qvw.

[MayilVahanan]

HI

You can create a master calendar and use tat.

[#4]

Hi...

You can create a Master Calendar having all the dates and then join it with the Hire Date and Termination Date in the script.

And then use the date from the Master Calendar..

For Tips to create a Master Calendar refer the link by @Josh Good:

http://community.qlik.com/thread/48693

[jonathandienst]

Hi

The best way to do this is to use one of the year fields in the list box, and link the other year using a set expression. Assuming you use [Hire Date] in the list box:

     Hire Count = Count(EmployeeID)

     Termination Count = Count({<[Termination Date] = P([Hire Date])>} EmployeeID)

Or you could use a Date island (another date field not connected to the rest of the model):

     Hire Count = Count({<Hire Date] = P([Island Date])>} EmployeeID)

     Termination Count = Count({<[Termination Date] = P([Island Date])>} EmployeeID)

HTH

Jonathan