topic Re: Date Sorting issue in QlikView

Date Sorting issue

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

I have this rather odd issue.

I have a bar chart where I'm sorting by total sales and customer. I have an additional metric where I'm comparing month to month. But the order in which everything shows up is odd.

Can anyone help me sort these dates?

Thanks,

Troy

Re: Date Sorting issue

swuehl — Thu, 23 Jun 2016 22:05:50 GMT

Could you be a bit more specific how you do the sorting and how your dimensions and expressions look like?

If possible, please post a small sample QVW.

Re: Date Sorting issue

shearwatertroy — Thu, 23 Jun 2016 22:14:32 GMT

I'm using Qlik Sense 2.0.1

I have sales data for customers. Some of them will buy product every few months, others will buy product monthly.

My dimensions are: Customer Name, YearMonth

year month returns the dates at MMM-YYYY

My Measure is: Sum(Sales)

I cannot supply the data as it is confidential.

Re: Date Sorting issue

johnw — Thu, 23 Jun 2016 22:15:59 GMT

I think I'm missing something. If you're sorting by total sales and customer, wouldn't we expect the months to show up out of order? I would only expect the months to be in order if you were sorting by month?

Re: Date Sorting issue

oknotsen — Thu, 23 Jun 2016 22:22:13 GMT

Please note that you have missed a bunch of service packs.

Consider patching to 2.0.9 (or wait a few days and go up to 3.0.x).

Re: Date Sorting issue

shearwatertroy — Thu, 23 Jun 2016 22:23:02 GMT

The people viewing this report are being driven crazy by the ordering of the months/years. But they want to see the data.

Re: Date Sorting issue

maksim_senin — Thu, 23 Jun 2016 22:56:02 GMT

Hi Troy,

Sometimes people don't understand the nature of data and don't want even to try understanding this since they have some stereotypes "as it should be".

QV not only helps to see what you have but also (and frequently) it helps to understand what you have.

Maybe this is your/them issue.

Best regards,

Maxim

Re: Date Sorting issue

swuehl — Thu, 23 Jun 2016 23:03:31 GMT

From what you have posted so far I am a bit unsure what the exact issue is.

Is it that your clients want the bars sorted in one way (by sales), but the legend in another (chronological)?

Re: Date Sorting issue

shearwatertroy — Fri, 24 Jun 2016 14:47:07 GMT

They would like to see the chronological order. But now that I'm viewing the raw data, I can understand what Maxim is saying.

It is sorting the data by the month/year of highest sales, which makes complete sense. Although from a presentation perspective it seems disorganized and without a proper explanation to those viewing the sheet they would be confused.