Qlik script version of T-SQL

[jtworks]

I want the Qlik script equivalent of :

SELECT TOP 1 [City]
, SUM([Amount]) As Amount
FROM Table
GROUP BY [City]
ORDER BY SUM(Amount) DESC;

[anat]

table1:

select  City,Amount from table;

noconcatenate

table2:

load city,sum(Amount) resident table1 group by city order by 2 desc;

drop table table1;

[jtworks]

Thanks for your response. This however did not work, it is also missing in TOP 1 clause. I just want to have the City with the highest sales.

[Or]

Have a look at e.g.

https://community.qlik.com/t5/QlikView-App-Dev/Get-Top-N-Records-from-a-Table-based-on-Group-by/td-p...

Similar question, so you should be able to adapt that to your scenario.

[jtworks]

Thanks for the reference. It is closer but it is listing all other states. I just want only the state with highest sales.