Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

izzatazfar8
New Contributor II

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.

izzatazfar8
New Contributor II

Re: Rank to High Medium Low

Hi, I try use te code but nothings changed