Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

Find Rank using Firstsortedvalue

Hi Hello,

I have a data like this:

IDID NAMELAYERPERIODR STATUS
1216AAPP01-01-2017-30-12-2017COMP
1216BAPP01-01-2017-30-12-2017PEND
1216CDB01-01-2017-30-12-2017SCOPE
1216DOS01-01-2017-30-12-2017NOTAVBLE
1217AAPP01-01-2017-30-12-2017NOTAVBLE
1217CAPP01-01-2017-30-12-2017PEND
1217DDB01-01-2017-30-12-2017COMP

If one ID has more then one R STATUS ,then we need to calculate rank based on below table.

R STATUS, RANK:

COMP,1

PEND,2

SCOPE,3

NOTAVBLE,4

RESULTS:

IDID NAMELAYERPERIODR STATUS
1216AAPP01-01-2017-30-12-2017COMP
1216CDB01-01-2017-30-12-2017SCOPE
1216DOS01-01-2017-30-12-2017NOTAVBLE
1217CAPP01-01-2017-30-12-2017PEND
1217DDB01-01-2017-30-12-2017COMP

Thanks,

Gireesh

0 Replies