topic Re: Group by in preceding load. in QlikView

Group by in preceding load.

qliktech_uk — Thu, 12 Oct 2017 11:03:31 GMT

Hi,

Is group by allowed in precedingg load?

Or we have to group it in the main load and take the summary data into preceding load?

thanks

Re: Group by in preceding load.

Anil_Babu_Samineni — Thu, 12 Oct 2017 11:05:46 GMT

Yes, Allowed

Re: Group by in preceding load.

rubenmarin — Thu, 12 Oct 2017 11:08:09 GMT

Hi, it should work,I tested with this script:

Data:

LOAD Articulo,

Fecha,

Sum(Ventas) as Ventas

Group By Articulo, Fecha;

LOAD * Inline

[

Articulo, Fecha, Ventas

A1 ,01/01/2017, 10

A1 ,01/01/2017, 80

A1 ,02/01/2017, 20

A2, 02/01/2017, 30

];

Re: Group by in preceding load.

Peter_Cammaert — Thu, 12 Oct 2017 11:12:45 GMT

Be very careful. You will get all sorts of side-effects that you cannot immediately explain. And yes it may work on simple examples. But those are not necessarily what you need in your situation.

Better use simple things in a Preceding LOAD, and do the GROUP BY in a separate operation on an internal table.