Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Merge Month and Year beside each other in qlikview

Hi,

I have Year and Month fields in QlikView and I need YearMonth beside each other like:

Year:2015

Month:05

YearMonth: 201505

How can I do it?

6 Replies
Highlighted

Re: Merge Month and Year beside each other in qlikview

Try this:

Date(MakeDate(Year, Month, 1), 'YYYYMM') as YearMonth

Highlighted

Re: Merge Month and Year beside each other in qlikview

or

Date#(Year&Month, 'YYYYMM') as YearMonth

Highlighted
Creator
Creator

Re: Merge Month and Year beside each other in qlikview

Try this:

Date(MakeDate(YEAR, MONTH), 'YYYYMM') as YearMonth

Highlighted
Master III
Master III

Re: Merge Month and Year beside each other in qlikview

Hi,

Try this in backend:

Year(Datefield) & ' ' & Month(Datefield) as YearMonth

Thanks,

AS

Highlighted

Re: Merge Month and Year beside each other in qlikview

Create Field in script

date#(Year &Month,'YYYYMM') as YearMonth

Highlighted
Not applicable

Re: Merge Month and Year beside each other in qlikview

concat fields in edit script to get result

Year&Month as YearMonth

concat fields as a calculated dimension to use in any Qlikview object

or also use same in list box defining custom expression.


Year&Month

Regards,

Zain.