topic Re: Cannot sort a bar chart that displays week in QlikView

Cannot sort a bar chart that displays week

Wed, 23 Nov 2016 10:56:18 GMT

Hi Guys,

This is my first post because I am seriously stuck and need some help! I have a barchart with a date dimension wich can switch between week/month/year. However, whatever I try, I cannot sort the x axis on the selected date range.

The graph shows weeks that span across a year, so selected week 46 from 2015 till week 5 from 2016. How can I sort this such that the graph starts at week 46 2015 and ends at week 5 2016? None of the sort buttons work in sort tab and neither does the sort by expression (they really don't do anything for this graph).

Thanks in advance!

Re: Cannot sort a bar chart that displays week

lironbaram — Wed, 23 Nov 2016 11:01:44 GMT

couple of option

you can select to sort the week field by expression

and assuming the week are connected to dates you can go with

=max(Date) in the expression or if it's connected to year

you can use an expression like this =Year*100+week

Re: Cannot sort a bar chart that displays week

giakoum — Wed, 23 Nov 2016 11:15:36 GMT

Just create a YearWeek field in your reload script and sort the bar chart with that field

Re: Cannot sort a bar chart that displays week

Wed, 23 Nov 2016 11:17:36 GMT

Thanks for the quick response! However we already tried these solutions and they didnt work. We even tried loading the week into the load script instead of calculating it.

Re: Cannot sort a bar chart that displays week

Wed, 23 Nov 2016 11:29:11 GMT

Thanks for the response! We tried it and the the bars got reversed on the axis. However we still cannot deleted the empty parts in the middle and every sort option still doesn't work.

Re: Cannot sort a bar chart that displays week

giakoum — Wed, 23 Nov 2016 12:03:25 GMT

is Continuous checked in the axis?

Re: Cannot sort a bar chart that displays week

Wed, 23 Nov 2016 12:05:41 GMT

wauuuww that was it! Thanks! It appear that if this option is checked than none of the sort functions work, which is, kind of obvious if you think about it.

Thanks!!

Re: Cannot sort a bar chart that displays week

giakoum — Wed, 23 Nov 2016 13:52:46 GMT

Please close the thread by marking the correct answer