1 Reply Latest reply: Nov 8, 2017 1:59 AM by P M RSS

    how to implement this in qlik sense

    poojashri bangera

      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;