Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

Try this:

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

sunny_talwar

or

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

Anonymous
Not applicable
Author

Try this:

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

amit_saini
Master III
Master III

Hi,

Try this in backend:

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

Thanks,

AS

Kushal_Chawda

Create Field in script

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

Not applicable
Author

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.