topic Order by with where in QlikView

Order by with where

Tue, 02 Aug 2011 13:34:17 GMT

I have a resident table, and a condition that only works correctly with order by.

But i also need to drop the results that don't satisfy the condition.

How can i do this, once it's not possible to use Order by with Where?

Order by with where

Tue, 02 Aug 2011 13:45:30 GMT

Hi, I think it can be easier to see what you are trying to achieve if you could post some sample code, however I will take my chances without further information, so you may try something like this:

//Here you order the table in the needed way

Temp:

Load yourfields

resident table

order by A;

//Here you apply the condition and keep only those records of interest

Fact:

noconcateante

Load yourfields

resident temp

where yourcondition;

//clean up the ordered table

drop table Temp;

Regards

Order by with where

Tue, 02 Aug 2011 14:12:33 GMT

Yes, that's it

i did like this before but i had forgotten the noconcatenate.

many thanks!