Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted

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;