topic Re: Sort year-week in graph in QlikView

Sort year-week in graph

stekol61 — Tue, 15 Jan 2019 13:26:19 GMT

Hi!

I have a graph that can present data per month or per week.

For week, this expression is used
Year(inc_create_date)&'-'& Week (inc_create_date)as Week,

The graph uses this sort expression:
Sort by expression:
=Max(Month(inc_create_date))

But the sorting in the graph is not correct.

How can this be solved?

Re: Sort year-week in graph

sunny_talwar — Tue, 15 Jan 2019 13:29:43 GMT

How about if you create your week field like this

Dual(Year(inc_create_date)&'-'& Week (inc_create_date), WeekStart(inc_create_date)) as Week,

and then sort it numerically

Re: Sort year-week in graph

pradosh_thakur — Tue, 15 Jan 2019 13:33:43 GMT

try sorting with

by expression
num(weekstart(inc_create_date))

by number/numeric sort

use expression as
dual(Year(inc_create_date)&'-'& Week (inc_create_date)as Week, num(weekstart(inc_create_date)))

Re: Sort year-week in graph

stekol61 — Tue, 15 Jan 2019 13:43:08 GMT

Hi!

After a closer check I notice that the x-axis dimension uses a Master item object (=[$(vDim)]).

I think is uses Week and Month from this:
Dims:
LOAD
Dim,
RowNo() as DimSort
INLINE [
Dim
Week,
Month
];

Not sure if your suggestion still can be used?

Re: Sort year-week in graph

sunny_talwar — Tue, 15 Jan 2019 13:55:29 GMT

I believe it should work... can you give it a shot.

Re: Sort year-week in graph

stekol61 — Tue, 15 Jan 2019 14:02:36 GMT

The result looks a little different but still not OK

Re: Sort year-week in graph

sunny_talwar — Tue, 15 Jan 2019 14:19:06 GMT

Is this view based on a selection? If it is, do you have set analysis in your expression to ignore selection in Week field or any other date and time field?

Re: Sort year-week in graph

stekol61 — Tue, 15 Jan 2019 14:26:07 GMT

Hi!

The selection used is 'Week'. The graph should be able to show 'Week' or 'Month' data base on a selection.
That's why the Master item and the Dims load is used

Re: Sort year-week in graph

sunny_talwar — Tue, 15 Jan 2019 14:49:08 GMT

I understand that... but I am not sure what all do you select in your dashboard except for selecting Dim.... would you be able to share a sample so that we can see your issue?

Re: Sort year-week in graph

stekol61 — Tue, 15 Jan 2019 15:08:31 GMT

Hi!

Changed the MonthNames from jan.;feb.;mars;...... to 1;2;3;....
Then sorted the x-axis 'Alphabetically'
This seems to solve the problem with sorting for both Week and Month