topic Re: Sorting error in App Development

Sorting error

Anonymous — Wed, 06 Dec 2017 12:45:26 GMT

Hello Qlik Community,

I'm having some trouble figuring out this problem:

In 2 of my visualizations I use the same dimension and sorting parameters, yet the sorting is different.

In attachment "qlik.png" you can see that the month November is slipping in between the others as "2017-Nov".

In attachment "qlik3.png" you can see the other visualization, where the sorting is correct.

Granted, the sorting is set to "auto" at the moment, yet the other options didn't make a lot of sense either.

The used dimension is described as follows:

=Year(floor([transactions.date])) & '-' & Month(floor([transactions.date]))

I have considered using the wildmatch function as a sorting expression, but that won't let my sort by year first.

Can anyone help me sort this out?

Re: Sorting error

sunny_talwar — Wed, 06 Dec 2017 16:26:14 GMT

Use this as your dimension

Date(MonthStart([transaction.date]), 'YYYY-MMM')

and then sort numerically

Re: Sorting error

Anonymous — Thu, 07 Dec 2017 09:07:02 GMT

Hi Sunny,

nice to meet you here again.

I tried your solution, and it works in principle, but the formatting of the labels is off.

As you can see in the attachment it still uses the date produced by the MonthStart function.

Any hints?

PS: This is how my dimension looks like: "=Date(MonthStart([transactions.date]), 'YYYY-MMM')"

Edit: Seemingly also because of this change, there appears a useless scrollbar beneath the visualization. It does not disappear if I increase horizontal or vertical size of the visualization.

Re: Sorting error

sunny_talwar — Thu, 07 Dec 2017 12:19:08 GMT

I guess continue using this as your dimension

=Year(floor([transactions.date])) & '-' & Month(floor([transactions.date]))

but sort using this expression

(MonthStart([transaction.date])

Re: Sorting error

Anonymous — Thu, 07 Dec 2017 12:58:34 GMT

I tried that, but the original error reoccurred.

Re: Sorting error

sunny_talwar — Thu, 07 Dec 2017 13:01:12 GMT

original error?

Re: Sorting error

Anonymous — Thu, 07 Dec 2017 13:05:32 GMT

Well, the November entry is back between the others again, as described in the question description.

Re: Sorting error

sunny_talwar — Thu, 07 Dec 2017 13:06:04 GMT

Would you be able to share a sample where we can see the issue?

Re: Sorting error

sunny_talwar — Thu, 07 Dec 2017 13:06:33 GMT

Mocked up data will work as well... all that matters is that you can recreate the issue in a sample file

Re: Sorting error

Anonymous — Thu, 07 Dec 2017 15:14:39 GMT

Well this took some time.

Tried to keep it as close to the actual data as possible without revealing anything important.

Re: Sorting error

sunny_talwar — Thu, 07 Dec 2017 15:28:44 GMT

Don't know really know why, but this works

=MonthStart(Min({1}[transactions.date]))

Re: Sorting error

Anonymous — Thu, 07 Dec 2017 15:45:59 GMT

Great, thanks!