GROUP BY 3 Tables

[Salazahr]

Hi,

I tried to put 3 tables together in Qlik and group by them then:

Spoiler

LOAD
          ID
         parameter1,
         parameter2,
         parameter3,

SUM(parameter3) AS SUM_parameter3

FROM file1.qvd (qvd);

LEFT JOIN (file1)
LOAD
         parameter1
FROM file2.qvd (qvd);

LEFT JOIN (file1)
LOAD
         parameter2
FROM file3.qvd (qvd)

GROUP BY
         parameter1,  parameter2;

This is obviersly wrong. I want to load 3 tables, join them with the first one, and want GROUP BY the 2 named parameters. What is the problem there?

Thanks for advice.

[Digvijay_Singh]

Are you getting any error?  Please share if you see any. I assume this is not the actual code you have used, Join statement syntax is LEFT JOIN instead of JOIN LEFT. You got total 3 fields, aggregating Para3 and using rest two in group by so that looks okay to me.

[Salazahr]

Your completly right, in my original code I used "LEFT JOIN" the correct way.