Grouping of Dates

[umartareen]

Hi,

How can we group different fields of dates into one single field ? For a better understanding, please find the attachment. As shown in the file attached, how can we group all those date fields into one Date field ?

Regards

Umar

[jerem1234]

Try using a crosstable like:

Construction:

CrossTable(MonthYear, Date, 1)

Load ...

From...

Then you can get rid of MonthYear field if you want.

Hope this helps!

[joshabbott]

Looks like an 'Interval Match' may work perfect for you.  You'll need to add start and end dates to your source.  Here is a blog on this:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

Hope that helps!