Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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