topic Sorting Problem (Bar Chart) in QlikView

Sorting Problem (Bar Chart)

markmm — Wed, 25 Jan 2012 15:32:34 GMT

Hi,

I have added a test application in which you see two charts (bar/straight table) sorted by a numeric date for that the weeks are in ascending order. the sorting works in in table, but in the bar chart (sort by expression) it doesn't work. I don't know why?

thanks for answer

Re: Sorting Problem (Bar Chart)

Wed, 25 Jan 2012 15:35:14 GMT

Try sorting by numeric value.

Sorting Problem (Bar Chart)

stephencredmond — Wed, 25 Jan 2012 15:37:15 GMT

Hi Mark,

The problem here is that there is not just one Num.Date value for each week so the Sort expression will return multiple values and that is, essentially, null.

You need to return just one of the values so use Max or Min:

max(Num.Date)

Regards,

Stephen

Sorting Problem (Bar Chart)

stephencredmond — Wed, 25 Jan 2012 15:41:56 GMT

Hi Mark,

You should mark the response as "Correct Answer".

Thanks,

Stephen