Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to Concatenate 2 or more columns to create a listbox

Hi Everyone,

I have a requirement where in provided with MONTH, DAY AND YEAR as separate columns create a list box concatenating all 3 columns.

INPUT:

MONTH     DAY     YEAR

JAN           02        2013

DESIRED OUTPUT:

DATE_COLUMN

2013-JAN-02

Thanks in Advance!

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Hi!

In List Box Properties, you can select an Expression in the "Field" comboBox, as the following picture.ListBox.jpg

In that expression, you can do something like this.

YEAR & '-' & MONTH & '-' & DAY

Other option is to create this dimension on your load, this way:

MONTH & '-' & DAY & '-' & YEAR as DATE_COLUMN

Regards,

Gabriel

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

Hi!

In List Box Properties, you can select an Expression in the "Field" comboBox, as the following picture.ListBox.jpg

In that expression, you can do something like this.

YEAR & '-' & MONTH & '-' & DAY

Other option is to create this dimension on your load, this way:

MONTH & '-' & DAY & '-' & YEAR as DATE_COLUMN

Regards,

Gabriel

View solution in original post

Highlighted
Not applicable

Thanks much Gabriel.. Worked like a charm!