topic Ranking multiple fields in App Development

Ranking multiple fields

cluscombe — Fri, 11 Aug 2017 21:35:41 GMT

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

Re: Ranking multiple fields

antoniotiman — Sat, 12 Aug 2017 06:17:49 GMT

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

Re: Ranking multiple fields

passionate — Sat, 12 Aug 2017 06:41:46 GMT

HI Chris,

I think this might help.

Regards,

Pankaj

Re: Ranking multiple fields

cluscombe — Sat, 12 Aug 2017 13:05:06 GMT

That worked perfectly! Thanks Antonio! Really appreciate it.