Ranking multiple fields

[cluscombe]

Hey All -

Trying to write script function that will allow me to rank based on multiple fields.I am trying to rank the transitions a JIRA Key went through, but I want to rank by the JIRA Key, then Status, and then Time Out.

Including an example excel file, the "Rank" column are the results I am trying to replicate in QlikSense.

Idea being I can use then flag (filter) in my UI to limit visualizations based on if the transition was the first transition for that given Status and Key.

Hope that makes sense.

Chris

[antoniotiman · Accepted solution]

Hi Chris

Temp:
LOAD [JIRA Key],
Status,
[Status Time Out]
FROM

(ooxml, embedded labels, table is Sheet1);

LOAD *,AutoNumber(RowNo(),[JIRA Key]&Status) as Rank
Resident Temp
Order By [JIRA Key],Status,[Status Time Out];
Drop Table Temp;

Regards,

Antonio

[passionate]

HI Chris,

I think this might help.

Regards,

Pankaj

[cluscombe]

That worked perfectly! Thanks Antonio!  Really appreciate it.