3 different month fields as 1 month list box

[knightwriter]

Hi All,

I have 3 different month field tables; Planned.Date, Due.Date & Completed.Date and I want to create a single List Box by month so that when I select Jan the data shown is that of only Jan for the Planned.Date, Due.Date and Completed.Date and not just the expression of one. Hope that makes sense.

Best,

Stephen

[mjayachandran]

I'm assuming all the dates are in 3 different tables, You can try linking all dates to a master calander

Creating A Master Calendar

[MK_QSL]

Canonical Date

[Anonymous]

Also see this:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date