Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qliktech_uk
New Contributor III

Group by in preceding load.

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

Tags (1)
3 Replies

Re: Group by in preceding load.

Yes, Allowed

Life is so rich, and we need to respect to the life !!!

Re: Group by in preceding load.

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.

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.

Community Browser