Using the Gauge chart and setting range limits to count numbers of text and displaying as %
Hi Qlik network, would really appreciate some help.
I am using data on how people feel about the market, negatively, neutral, or positively. I have 665 entries and I want the chart to show those who put negatively as a limit, and then positively as another limit. So I am trying to make it count these using the below formual in the range limits: count({<[Outlook]={"*Negatively*"}>} [Outlook]), and then count({<[Outlook]={"*Positively*"}>} [WFH Impact]).
On the data section I've just put count([Outlook]). Ideally I'd like it to show a % figure in the middle instead of the count.
The chart is just counting the number of entries right now, and the colours aren't working as they should.
Any thoughts or help on what may be going wrong much appreciated!
If I understand your issue correctly, you need to modify the definition of the limits. I think the second limit (those that reacted positively) needs to be adjusted. In order to position the gauge limits properly, you should be counting everyone who didn't respond positively:
Let's assume that 20 people reacted negatively, 50 people reacted neutrally, and 40 people reacted positively. So, out of the total of 110 people, the ranges should be set as follows:
Range 1 - from 0 to 20 (negative)
Range 2 - from 21 to 70 (negative + neutral)
Range 3: from 71 to 110 (total)
So, in this example the first limit should be 20 (count of negative entries) and the second limit should be 70 (count of all entries except for positive)
Does it make sense, or did I miss the essence of your issue?
To learn more advanced development techniques, including advanced Set Analysis, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!
