Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
If i understand your requirement correctly you will have to do an Inline Load.
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
Use below code in Script.
pick(Wildmatch(Category,'1','2','3'),'High','Medium','Low') as NewCategory
Use NewCategory as field
put that script at which line?
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
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.
Hi, how do I edit the legend title?
It should show title as Risk because you have given 2nd dinension label as Risk.
That will be used as Title for Legend