Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Prevent group by from joining to the main table

Hello all,

When using group by, how can i change the field name that I'm grouping by in the new table so that the new table is not joined to the main table? I don't want them to be connected, just want the new table as a separate table.

NewTable:

Load

     field1,

     Sum(field2) as GroupSumfield2

     Resident [MainTable]

Group by

  field1;

Now the new table has field1 and GroupSumfield2, but I want it to have field1 renamed as a new name so that it's not joined to my MainTable.When I also do field1 as field1new then the sum doesn't work appropriately and it created many records from each record not sure why

1 Reply

Re: Prevent group by from joining to the main table

This:

NewTable:

Load

     field1 as Newfield1,

     Sum(field2) as GroupSumfield2

     Resident [MainTable]

Group by

  field1;