topic Re: Order bar chart by Date Timestamp field in QlikView

Order bar chart by Date Timestamp field

Fri, 10 Aug 2012 13:23:40 GMT

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

Re: Order bar chart by Date Timestamp field

Fri, 10 Aug 2012 13:26:27 GMT

Try this instead:

date(ContactCreatedDate, 'MMM - YYYY')

Re: Order bar chart by Date Timestamp field

Fri, 10 Aug 2012 13:27:28 GMT

Right after I posted this I checked the 'Numeric Value' box in the sort tab and it works fine now. More luck than skill!