Removing Duplication? - Qlik Community - 1425592

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

I have a table for example

ID,Time

A,120

A,230

A,100

B,50

B,100

I want to store this table in qvd as

ID,TIme

A,450

B,150

So I can use that Qvd in other application

1 Reply

Try this.

RawData:

Load * inline [

ID,Time

A,120

A,230

A,100

B,50

B,10

];

Aggregate:

noconcatenate Load ID, Sum(Time) as Time Resident RawData group by ID;

Store Aggregate into Aggregate.qvd;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!