Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a requirement where in provided with MONTH, DAY AND YEAR as separate columns create a list box concatenating all 3 columns.
MONTH DAY YEAR
JAN 02 2013
Thanks in Advance!
In List Box Properties, you can select an Expression in the "Field" comboBox, as the following picture.
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
View solution in original post
Thanks much Gabriel.. Worked like a charm!