Discussion board where members can get started with Qlik Sense.
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?
You could load the 'doability' field as a dual value. In your load script:
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.
Hi, I try use te code but nothings changed