5 Replies Latest reply: Oct 9, 2015 9:39 AM by Jonathan Poole RSS

    Rank function in qlik sense

      Hi,

      If I have to display the rank on the basis of amount and alphabetically,then what would be the syntax for the same. could anyone please help me out?

      name                    amount

      piyush chawla        100

      piyush singh           100

      raj arora                  50

      raj singh                 50

      Then the rank should be

      name                    amount     rank

      piyush singh            100          2

      piyush chawla          100          1

      raj arora                  50            3

      raj singh                 50            4