Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
izzatazfar8
New Contributor III

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?

Tags (2)
2 Replies
MVP
MVP

Re: Rank to High Medium Low

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
izzatazfar8
New Contributor III

Re: Rank to High Medium Low

Hi, I try use te code but nothings changed