Group by wokring in SQL but not in Qlik

[AutoMann]

Hi all,

this statement works in SQL, giving me distinct values for ID.

But in Qlik I get a result with multiple ID.

Qlik statement:

[PriorityList]:
Load
max([Prio]) as myMax
Resident [Tabelle]
Group by [ID]
;

SQL Statement:

SELECT [Tabelle].ID, Min([Tabelle].Prio) AS MaxPrio
FROM [Tabelle]

GROUP BY [Tabelle].ID;

[sergio0592 · Accepted solution]

Hi,

Where is your ID field in your Qlik statement?

[PriorityList]:
Load
[ID]
max([Prio]) as myMax
Resident [Tabelle]
Group by [ID]
;

[marcus_malinow · Accepted solution]

Hi,

I think you need to add your GROUP BY field to your LOAD.

e.g.

[PriorityList]:
Load

[ID], 
max([Prio]) as myMax
Resident [Tabelle]
Group by [ID]
;