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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

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.