Rank High,Medium and Low

[Anonymous]

Hi I'm in new in Qlik Sense.In my attachment, in excel named Phase & Cat is the Top Risk for every Phase.

3 = Low Risk

2 = Medium Risk

1 = High Risk

I used bar chart to show the risk for every risk. My question is what is the best visualization to show these risks?

I want to replace the number 3 to Low, 2 to Medium and 1 for High. Can anyone show the step by step for me? Thank you

[psk180590]

Hi,

If i understand your requirement correctly you will have to do an Inline Load.

[bwisealiahmad]

Hi Izzat,

Make a inline mapping table that you can use to replace the numbers with the label that you want:

RiskLabelMapping:

Mapping LOAD * INLINE [

    RankID, Label

    1, High

    2, Medium

    3, Low

];

And then you apply this to the field with the RankIDs

Applymap('RiskLabelMapping', FieldIdName) AS RiskLabel

[shraddha_g]

Use below code in Script.

pick(Wildmatch(Category,'1','2','3'),'High','Medium','Low') as NewCategory

Use NewCategory as field

[Anonymous]

put that script at which line?

[Anonymous]

which line to put

Mapping LOAD * INLINE [

    RankID, Label

    1, High

    2, Medium

    3, Low

];

and which line to put

Applymap('RiskLabelMapping', FieldIdName) AS RiskLabel

[bwisealiahmad]

The line table goes above the table where you have the data and the script line goes in the table that specifies columns from the data table.

[Anonymous]

Hi, how do I edit the legend title?

[shraddha_g]

It should show title as Risk because you have given 2nd dinension label as Risk.

That will be used as Title for Legend