Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lishuang
New Contributor III

individual data values too low

Hi All,

when the individual data values are lower,with the bar chat can't show their comparison.How can i solve this problem?

3.png

Thanks in advance!

1 Solution

Accepted Solutions
kangaroomac
Contributor II

Re: individual data values too low

There is a huge difference between 7.6M and 279K (largest compared to second largest measured dimension).

Showing them on the same chart as with your other values and to make visual sense would require a very large screen.

Alternatively you could remove your outliers (exclude them in your chart by using select excluded (after selecting them)).

Select Excluded.png

Probably not what you want to hear, but visually presenting outliers for comparison with such a big difference in values will be a challenge.

Ps. Have you tried converting your bar chart to a tree map to see the result?

4 Replies
rittermd
Honored Contributor

Re: individual data values too low

I think the problem is that you have one bar that is so much larger than all of the rest of them.  Do you have to have that bar in this chart?

Do bars show up as you scroll down using the scroll on the right.

You also may be able to adjust the scale in the axis properties or set a custom range.

xufei123
Valued Contributor

Re: individual data values too low

Split it to two charts.

One with the "Huge one" and ""Others".

The other one does not include the huge one so only compare within the rest.

Fei

lakshmikandh
Valued Contributor II

Re: individual data values too low

Try changing scale in the Chart according the other values range

kangaroomac
Contributor II

Re: individual data values too low

There is a huge difference between 7.6M and 279K (largest compared to second largest measured dimension).

Showing them on the same chart as with your other values and to make visual sense would require a very large screen.

Alternatively you could remove your outliers (exclude them in your chart by using select excluded (after selecting them)).

Select Excluded.png

Probably not what you want to hear, but visually presenting outliers for comparison with such a big difference in values will be a challenge.

Ps. Have you tried converting your bar chart to a tree map to see the result?

Community Browser