How to use between, greater than values in qlikview

[#1]

I am new to QV and had a question:

I have 2 excel sheets:

1. Input data

Security ID	Rating
XXXX1	iAA+
XXXX2	iAAA
XXXX3	iAA-
XXXX4	iAAA

2. Reference sheet

Priority	S&P	Mixed Rating
1	AAA	iAAA
2	AA+	iAA+
3	AA	iAA
4	AA-	iAA-

I have the following requirement:

1. I want all security id with ratings > iAA-

2. I want all security id with rating = iAAA

3. I want all security id with rating between iAA- and iAA+ (i.e. excluding iAAA)

How do I go about creating this in Qlikview? Both these files are required to be completely loaded.

[Gysbert_Wassenaar · Accepted solution]

Assuming Priority can be used as a ranking... see attached example.