Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Regards,
Antonio
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
Regards,
Antonio
HI Chris,
I think this might help.
Regards,
Pankaj
That worked perfectly! Thanks Antonio! Really appreciate it.