topic Re: Qlik script version of T-SQL in App Development

Qlik script version of T-SQL

jtworks — Wed, 22 Dec 2021 16:28:40 GMT

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 — Mon, 20 Dec 2021 07:39:06 GMT

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 — Mon, 20 Dec 2021 09:36:30 GMT

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 — Mon, 20 Dec 2021 10:10:46 GMT

Have a look at e.g.

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

jtworks — Mon, 20 Dec 2021 15:49:34 GMT

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