Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rank to High Medium Low

Hi, refer to the attachment, My data on "doability' are 1,2,3,4 and 5 which means the level of difficulty. I want to show on scatter plot showing 1 as Low, 2 as Medium, 3 as High , 4 as Critical and 5 as SUper critical. How can do i it?

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

You could load the 'doability' field as a dual value. In your load script:

LOAD

  ...

  Pick(doability, dual('Low', 1),  dual('Medium', 2), dual('High', 3), dual('Critical', 4), dual('Super critical', 5)) as doability,

  ...

Now doability will show the names. Sort the chart numerically to get the doability in the correct order.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Hi, I try use te code but nothings changed