Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
navaneeth79
New Contributor II

Removing Duplication?

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

Re: Removing Duplication?

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

Community Browser