Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

combine date field

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

3 Replies
joshabbott
Contributor III

Re: combine date field

Do you just want them concatenated together?

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

Re: combine date field

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;

Not applicable

Re: combine date field


Thanks

Community Browser