topic Re: In which scenario does Group By not work during a certain type of Load? Add you have to do a Resident Load instead? in QlikView

In which scenario does Group By not work during a certain type of Load? Add you have to do a Resident Load instead?

jblomqvist — Tue, 09 Aug 2016 19:19:38 GMT

Hi,

I seem to recall that Group By is not possible for certain type of loads, and you have to do a Resident Load instead and then a group by.

Can anybody remind me when this rule applies?

sunny_talwar — Tue, 09 Aug 2016 19:23:02 GMT

That is true for Order By. Group by works everywhere, whereas, Order by can only work on Resident load