Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lockematthewp
Creator II
Creator II

Order By Help

I have a dashboard where I use the Peek function to get a date range. Because of this, I sort my reading dates in descending order (so the Peek function will grab the next highest date).

"ORDER BY [FUEL ASSET] asc, [READING DATE] desc;"

However, When I have two duplicate dates, the dates are backwards. Is there a way to sort by desc, but if they are equal dates to order them backwards?

Thanks,

Matt

2 Replies
sivakumar1994
Contributor III
Contributor III

please provide the code or snapshot , to view the issue clearly
Gysbert_Wassenaar

Uhm... it doesn't matter how you sort two equal dates...? They're equal so there is no order in which they can be sorted.


talk is cheap, supply exceeds demand