Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Hi,
Where is your ID field in your Qlik statement?
[PriorityList]:
Load
[ID]
max([Prio]) as myMax
Resident [Tabelle]
Group by [ID]
;
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]
;
Hi,
Where is your ID field in your Qlik statement?
[PriorityList]:
Load
[ID]
max([Prio]) as myMax
Resident [Tabelle]
Group by [ID]
;
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]
;