Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get disply value by concatenating 2 columns

Hi,

I have 2 columns Month(Jan, Feb, Mar....) and CalendaryYear(2011,2012,2013),

My requirement is i have to concatenate those 2 columns for that i am using below condition

Month & '-' & CalendaryYear as month

from this will get output like Jan-2011,Feb-2011,..

But i have to disply it like Jan-11,Feb-11,.....

Can any one suggest me to get this..

Thanks ,

Sh

1 Solution

Accepted Solutions
whiteline
Master II
Master II

Hi.

Month & '-' & Right(CalendaryYear,2)

View solution in original post

3 Replies
simondachstr
Specialist III
Specialist III

Month & '-' & right(CalendaryYear,2)

whiteline
Master II
Master II

Hi.

Month & '-' & Right(CalendaryYear,2)

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Or you could do this as a date value. This will mean that it will sort correctly (sort numerical):

Date(Date#(Month & ' ' CalendarYear, 'MMM YYYY'), 'MMM-YY')

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein