Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Converting string to month

Hi,

Is it possible to convert the string into Month. I have a column with string values like Jan-10,Feb-10.... I am trying to sort it in the original order as Jan,Feb ... in the bar chart. Since it is string the same can be done by converting the values to date format. Is there any other way to acheive this without changing the database level(Since huge data is there).

1 Solution

Accepted Solutions
Not applicable
Author

You need to use Date# function

In your example it should be date#(MyField,'MMM-YY')

Rgds,

Sébastien

View solution in original post

3 Replies
Not applicable
Author

You need to use Date# function

In your example it should be date#(MyField,'MMM-YY')

Rgds,

Sébastien

View solution in original post

Not applicable
Author

Thanks Sebastien,

It is working fine as expected.

Not applicable
Author

Great !