topic Re: Sort Order In Cyclic Group in QlikView

Sort Order In Cyclic Group

Muthu — Tue, 17 Mar 2015 13:12:27 GMT

Hi,

I am creating a chart with the cyclic group as dimension.

I have values like year month and week as the fields in the Cyclic Group,

I am selecting a filter in the calender range, august 2014 - March - 2015,

In the chart when I select the year its giving me correct values starting from August -2014,

as I have given condition in the group sort order ( Year & num(Month,00)),

I Tried giving the same kind of sort order expression for week, But its not giving the correct values,

Please help.

Muthu

Re: Sort Order In Cyclic Group

jpenuliar — Tue, 17 Mar 2015 13:16:33 GMT

Have you tried setting the Sort options in Group Settings?

Re: Sort Order In Cyclic Group

jpenuliar — Tue, 17 Mar 2015 13:19:48 GMT

Your Week is probably tagged as $Text in your Data Model, whereas the other Calendar fields are tagged $Numeric and you are sorting Week as Numeric

Re: Sort Order In Cyclic Group

Muthu — Tue, 17 Mar 2015 13:20:20 GMT

Hi Jonathan,

I tried doing that.

It didn't work

Re: Sort Order In Cyclic Group

sunny_talwar — Tue, 17 Mar 2015 13:23:17 GMT

What is your exact script for creating the week field?

Re: Sort Order In Cyclic Group

Muthu — Tue, 17 Mar 2015 13:28:47 GMT

Hi,

I have used Week(DateField)

Re: Sort Order In Cyclic Group

jpenuliar — Tue, 17 Mar 2015 13:32:09 GMT

And What are the Sort options you selected for this Field?

Re: Sort Order In Cyclic Group

sunny_talwar — Tue, 17 Mar 2015 13:38:06 GMT

Have you tried using Load order for sorting?

Re: Sort Order In Cyclic Group

Muthu — Tue, 17 Mar 2015 14:04:21 GMT

I tried giving expression and ascending order

Re: Sort Order In Cyclic Group

Muthu — Tue, 17 Mar 2015 14:05:03 GMT

I gave ascending order and the expression

Re: Sort Order In Cyclic Group

jpenuliar — Tue, 17 Mar 2015 14:07:15 GMT

attach your sample file to see your work and add what exactly is your required Sorting order

Re: Sort Order In Cyclic Group

sunny_talwar — Tue, 17 Mar 2015 14:37:36 GMT

Can you try the load order for once:

It may be greyed out for some charts, but if its available can you give it a shot.

Best,

Re: Sort Order In Cyclic Group

rubenmarin — Tue, 17 Mar 2015 14:48:20 GMT

Hi Muthu, If you have a date field related to each week, month..., in the settings for the group you can sort by expression using:

=Min({1}DateField)

This can be used for year, month, week...

Re: Sort Order In Cyclic Group

Or — Tue, 17 Mar 2015 14:54:41 GMT

You may want to try Weekname(myDate).

Re: Sort Order In Cyclic Group

awhitfield — Tue, 17 Mar 2015 15:33:44 GMT

Hi Muthu,

see if the attached example helps

Andy

Re: Sort Order In Cyclic Group

Muthu — Wed, 18 Mar 2015 05:27:46 GMT

Hi,

I tried giving load order,

It didn work.

Re: Sort Order In Cyclic Group

Muthu — Wed, 18 Mar 2015 05:29:00 GMT

Hi,

Thank you all for your answers,

Instaead of week(Mydate) I have taken WeekName(MyDate)

It worked.