topic Re: Others Label in Funnel Chart in QlikView

Others Label in Funnel Chart

qlikwiz123 — Sat, 16 Nov 2024 18:42:08 GMT

I created a funnel chart with Dimension Limits set and Labeling them as 'Other'.

But I don't see that label in the chart. But when i change the chart to a bar, it works. Please help

Re: Others Label in Funnel Chart

rubenmarin — Mon, 04 May 2020 09:51:22 GMT

Hi, maybe you have only 7 dimension values? if you set a lower number, like 'Largest 5 Values' it appears?

If not it should be because your expression is cheking for dimension values and 'Others' will have many different values, not only one.

Re: Others Label in Funnel Chart

qlikwiz123 — Mon, 04 May 2020 13:34:03 GMT

Hi,

I definitely have more than 7.

Isn't that the point of 'Others'? To consolidate all dimensions beyond Largest 7 to show as 'Others'? Like I said, it works in Bar chart but not funnel. I am guessing it might be a bug

Re: Others Label in Funnel Chart

rubenmarin — Mon, 04 May 2020 13:49:15 GMT

Yes, that's hpow it works, if there are more dimensions than the specified they show gouped in 'Others'.

I have tested and at least in April-2019 SR3 it should work.

Re: Others Label in Funnel Chart

qlikwiz123 — Mon, 04 May 2020 15:34:40 GMT

Yes, shows in the legend. But not inside the Funnel

Re: Others Label in Funnel Chart

rubenmarin — Wed, 06 May 2020 06:26:29 GMT

If I check the option to show values it shows values also in Others segment:

Re: Others Label in Funnel Chart

qlikwiz123 — Wed, 06 May 2020 20:42:25 GMT

Hi,

Yes, the values show up inside the funnel even in my chart (look at the attached image in the beginning of the post). But for some reason, the label is missing for 'Others'

Re: Others Label in Funnel Chart

rubenmarin — Thu, 07 May 2020 06:36:58 GMT

Ok, but how is set the label, maybe using dual() with the dimension value?

In that case I return to my first answer: If not it should be because your expression is cheking for dimension values and 'Others' will have many different values, not only one.

In expression you can check if there are many values and in that case set a fixed value for others, like:

Dual(If(Count(DISTINCT DimensionField)>1, 'Others', DimensionField) & Chr(10)& Expression, Expression)