Aggr to 1 row

[#1]

Hello,

I want to aggr the data in the source data to one row with only one unique timestamp.

Now I have sometimes in de source data two or three rows with the same timestamp. 

Data now

Timestamp                         A              B          C

10-02-2014 08:00              10

10-02-2014 08:00                               5

10-02-2014 08:00                                             6

Data in Qlikview

Timestamp                         A              B          C

10-02-2014 08:00              10             5           6

The data file and Qlv is attached.

Gr,

Ralph

[Gysbert_Wassenaar · Accepted solution]

You can just aggregate the values in charts and leave the data as it is. If you want to aggregate the data in the script then use something like this:

LOAD

     Timestamp,

     sum(A) as A,

     sum(B) as B,

     sum(C) as C

FROM

     ...source...

GROUP BY

     Timestamp

     ;

[PrashantSangle]

Hi,

create straight table.

take timestamp field as dimension

and expression

sum(A)

Sum(B)

Sum(C)

Sum(D)

and so on.

Regards

[#4]

Gysbert,

It works.

Thank you

Ralph.