topic Re: sorting by week in QlikView

sorting by week

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to create a chart sorting it by week but the problem is that I need to show the last weeks of the year then the 1st week of this year ..can any one help?

Re: sorting by week

Anil_Babu_Samineni — Mon, 08 Jan 2018 12:14:53 GMT

Can you please share sample

Re: sorting by week

Anonymous — Mon, 08 Jan 2018 12:17:54 GMT

week number	value
52 (2017)	80
1 (2018)	90
2 (2018)	100

Re: sorting by week

sunny_talwar — Mon, 08 Jan 2018 12:18:07 GMT

Sort using YearWeek field rather than just Week... YearWeek will make sure that sorting is also based on Year field and not just week field

Re: sorting by week

sunny_talwar — Mon, 08 Jan 2018 12:19:01 GMT

Create a new field in the script like this

(Year * 100) + Week as YearWeek

Re: sorting by week

Anonymous — Mon, 08 Jan 2018 12:19:07 GMT

can you explain more

Re: sorting by week

sunny_talwar — Mon, 08 Jan 2018 12:20:21 GMT

Create a new field like this

(Year * 100) + Week as YearWeek

and then may be use this as a dimension or use it for sorting purposes..

Re: sorting by week

Anil_Babu_Samineni — Mon, 08 Jan 2018 12:20:28 GMT

I would call Year as Sorting option instead Week number this case

Re: sorting by week

Anonymous — Mon, 08 Jan 2018 12:23:46 GMT

thanks , will try it now and update you

Re: sorting by week

Aditya — Fri, 05 Apr 2019 19:39:44 GMT

Hi,

But for the generic question - Can you sort a dimension by another? I ask this because in my case, I'd like to show only the week number (51, 52,01, 02..) and not the year-week; this is just for aesthetics. Is there a way to accomplish this? Show week numbers but sort the week number of year week? It works perfectly when you sort a dimension on measure (like sales etc.) but somehow it doesn't work when the expression is a dimension

Thanks,

Aditya

Re: sorting by week

nagaiank — Sun, 07 Apr 2019 02:20:07 GMT

Yes. You can use Week as dimension with YearWeek ascending as sort order.

Re: sorting by week

Vegar — Sun, 07 Apr 2019 14:59:40 GMT

@sunny_talwar wrote:
Create a new field in the script like this
(Year * 100) + Week as YearWeek

Be aware that week year expressions created by week and year field will have issues in December certain years.

E.g. 2018-12-31 which is in week 1! and year 2018, but it should not be considered as 201801, but 201901.

An better approach would be to create YearWeek using monthname(dateField,'YYYYMM')