how to implement this in qlik sense

[poojashribanger]

SELECT *

FROM

  (SELECT *

    RANK() OVER (PARTITION BY IS ORDER BY CATEGROY DESC) RNK

  FROM table_name

  WHERE  date  = '31-OCT-17'

  AND CATEGROY IN ('S','Special')

  AND ID IN ('284','315')

  )

WHERE RNK=1;

[prma7799 · Accepted solution]

Please check this

ROW_NUMBER() OVER(PARTITION BY PostalCode ORDER BY SalesYTD DESC) AS 'Row Number'

LEAD(...) OVER (PARTITION BY ... ORDER BY ...) | Qlik Community