I have the following data.
I want to load this data and then sort it. I need it in the following format.
I want to have the time being sorted Ascending, and because the WHO repeats, it needs to be grouped by WHO.
Example of required result.
As can be seen above, Qlikview actually sorts it Ascending according to time, however it does not group all the WHO (OrderNumbers) together. Can someone please assist?
I have been struggling getting ORDER BY to work correctly. it seems to Ignore the Sort.
Hi , Just had to have the correct sequence in the ORDER BY and have it in a Resident. Thanks. Solved it right after posting.
right(WHO,8) as WHO,
Order BY WHO desc,CONFIRMED_AT,VLPLA,;
drop table PRE;
View solution in original post
Order by only works with Resident Load, can you post the script you are using?