Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have loaded a field into Qlikview called ContactCreatedDate which contains dates in the format:
DD/MM/YYYY hh:mm:ss
I am using this field as a dimension in a bar chart with the expression:
=monthname(ContactCreatedDate)
Which formats it as Jan - 2009, Jun - 2012 etc. But when I try and order the bar chart by date it doesn't work. I have tried adding the ContactCreatedDate to the expression in the sort tab but this has no effect. Any ideas would be greatly appreciated!
Thanks
Try this instead:
date(ContactCreatedDate, 'MMM - YYYY')
Right after I posted this I checked the 'Numeric Value' box in the sort tab and it works fine now. More luck than skill!