Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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