topic Re: Sorting isssue in QlikView

Sorting isssue

Tue, 08 Jan 2013 19:28:07 GMT

I have a qlikview table that I want to sort according to the timestamp numeric value however I don't want to display that in my table. I want to display the 'user friendly' display of the month. I want to use the sort tab within the table properties to change the sort to be an expression using the column NUMFISCAL_TIMESTAMP however, the table isn't sorting the way I would expect it to. I would expect the table to sort according to the FISCAL_ACTUAL_BEGIN_DT (which the NUMFISCAL_TIMESTAMP column is based off of). Your assistance is greatly appreciated

Re: Sorting isssue

Tue, 08 Jan 2013 20:06:17 GMT

When I open your document it is sorted by date?

You can promote the column in the sort tab so that the one you want to sort on is listed first.

Re: Sorting isssue

Tue, 08 Jan 2013 20:11:25 GMT

The customer doesn't want to see the date field, they want to see the field called 'Display' I through the other fields in there for demonstration purposes. I know I need to use the Expression within the Sort tab however, that's not working the way I anticipated.

Re: Sorting isssue

Tue, 08 Jan 2013 20:22:50 GMT

I understand your expectation. When I open this document the data is in order by FISCAL_ACTUAL_BEGIN_DT ... but there is also very limited data here. With only these 12 records, one for each month, it does not appear to matter which you sort by because it stays in order.

Re: Sorting isssue

Tue, 08 Jan 2013 20:24:50 GMT

And these stay in order when I keep your sort funtion and delete the extra dimensions.

Re: Sorting isssue

Tue, 08 Jan 2013 20:27:00 GMT

That's funny cause this is what I come up with

Re: Sorting isssue

Tue, 08 Jan 2013 20:28:33 GMT

Re: Sorting isssue

Tue, 08 Jan 2013 20:30:00 GMT

Is there something wrong in my default? How am I set up differently than you are set up?

Re: Sorting isssue

Tue, 08 Jan 2013 20:33:08 GMT

That is strange. I opened your document and made no changes. Just to humor me, will you close the one you have open and open up the one you posted here?

Re: Sorting isssue

Tue, 08 Jan 2013 20:35:22 GMT

sorry, I don't see the one you posted

Re: Sorting isssue

Tue, 08 Jan 2013 20:36:32 GMT

no, open the one you posted from here. I have not made any changes at all.

Re: Sorting isssue

Tue, 08 Jan 2013 20:37:36 GMT

same sort order as I have posted previously. This is really strange, what setting of mine is different?

Re: Sorting isssue

Tue, 08 Jan 2013 20:38:58 GMT

post a screenshot of your sort properties for the chart

Re: Sorting isssue

Tue, 08 Jan 2013 20:41:38 GMT

Re: Sorting isssue

Tue, 08 Jan 2013 20:46:10 GMT

1st, i would try replacing your existing calculation with this:

= FISCAL_ACTUAL_BEGIN_DT

Re: Sorting isssue

Tue, 08 Jan 2013 20:46:29 GMT

If that does not work, open a ticket with QlikView. Seems you have a bug.

Re: Sorting isssue

Tue, 08 Jan 2013 20:47:48 GMT

Yeah, that didn't work. I had also tried that before. I will open a ticket. Thanks.