topic Re: combine date field in QlikView

combine date field

Wed, 30 Jul 2014 14:53:47 GMT

Please see my example below. How do I combine yearmonth and yearmonth2?

joshabbott — Wed, 30 Jul 2014 14:55:57 GMT

Do you just want them concatenated together?

year([Intake Date]) & '/' & month([Intake Date]) & ' - ' & year([Close Date]) & '/' & month([Close Date]) as CombinedDate

its_anandrjs — Wed, 30 Jul 2014 15:08:25 GMT

As i understand you have to create single field as yearmonth if so then again load the table and concatenate this tables

Ex:-

Load

year([Intake Date]) & '/' & month([Intake Date]) as yearmonth

and other fields

From Location;

Concatenate

Load

year([Close Date]) & '/' & month([Close Date]) as yearmonth

and other fields

From Location;

Mon, 11 Aug 2014 20:26:58 GMT

Thanks