Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
mrchmchr
New Contributor III

Scatter Plot Legend - Text adjustments

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