Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reduce data after binary load

Hi all,

I know that something similar was already posted but I can not find nothing that could help me.

So, I have upload data with Binary statement from another QVD, since it si very big dokument with so many data, i would like to agregate that huge amount of data and grouping it on for example months:

like this :

Select

Field 1,

Field 2,

Field 3,

Field 4,

month

Sum(amount)

Group by Field 1,Field 2,Field 3,Field 4, monht

What is the script for this and how this operationg not to be so memory consuming?

Thank you in advance..

0 Replies