Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
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;