Hi everyone,
I have created a scatter plot in Qlik Sense and I need to adjust the legend.
In "Colors and legend" - "by expression" I have sorted the data to 3 distinct categories via:
IF(X-Y>0.05*X,1,IF(X-Y<-0.05*X,2,0))
But somehow Qlik does not recognize that these are discrete values and shows a legend with 3 categories: 0 to 0.67, 0.67 to 1.33 and 1.33 to 2, which does not make sense at all!
Ideally I would like to give names to these categories, with 0 = Match, 1 = Exceeded and 2 = Beneath or something like that. But when I work with text instead of numerical values the legend fails completely.
It seems to me that this should be quite a basic functionality. Is there a way to accomplish that?
Thanks and regards,
Marco
