Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting isssue

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

Labels (1)
16 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

post a screenshot of your sort properties for the chart

Not applicable
Author

sort.png

Not applicable
Author

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

= FISCAL_ACTUAL_BEGIN_DT

Not applicable
Author

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

Not applicable
Author

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