topic Order By Help in QlikView

Order By Help

lockematthewp — Mon, 11 Mar 2019 16:02:28 GMT

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

Re: Order By Help

sivakumar1994 — Mon, 11 Mar 2019 17:21:02 GMT

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

Re: Order By Help

Gysbert_Wassenaar — Mon, 11 Mar 2019 17:38:17 GMT

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.