topic Re: Can I select one year from two different date fields? in QlikView

Can I select one year from two different date fields?

akile002 — Thu, 21 Nov 2013 17:43:16 GMT

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?

Re: Can I select one year from two different date fields?

jonasheisterkam — Thu, 21 Nov 2013 17:56:24 GMT

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.

Re: Can I select one year from two different date fields?

MayilVahanan — Thu, 21 Nov 2013 18:23:33 GMT

You can create a master calendar and use tat.

Re: Can I select one year from two different date fields?

Fri, 22 Nov 2013 06:07:21 GMT

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

Re: Can I select one year from two different date fields?

jonathandienst — Fri, 22 Nov 2013 06:17:43 GMT

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