Show "Other" in a Chart

[sinanozdemir]

Hello,

I am trying to show the unselected values in "other" label in a chart. In the below example, I need to show NJ and PA in another column labeled "Other":

Any feedback is appreciated.

Thanks

[sunny_talwar]

Like this?

Expression:

Pick(Dim, Sum(Amount), Sum({<State=e(State)>}Amount))

Script:

Sale:

LOAD * INLINE [

    Company, State, Amount

    A, NJ, 100

    B, PA, 200

    C, NY, 300

];

LOAD * Inline [

Dim

1

2

];

[Peter_Cammaert]

You're showing Companies in your chart. Do you mean other companies? Mixing dimensions is pretty difficult for an end-user to interprete.

[sinanozdemir]

I meant to say "Other Companies".

Thanks

[sinanozdemir]

Hi Sunny,

Preferably, not creating another inline load statement.

Thanks

[Peter_Cammaert]

But that means that Company '0' may appear twice in the same chart: once as a dimension value and once hidden somewhere in the Others bar. For a QlikView end-user this display may be a bit inconsistent.

[sunny_talwar · Accepted solution]

This may be:

If(Dimensionality() = 0,  Sum({<State=e(State)>}Amount), Sum(Amount))

[sunny_talwar]

I agree. It confused me when I was trying to create that kind of visual. I used State = e(State), but you might want to change if the requirement is different.

[sinanozdemir]

This is awesome.

Thanks Sunny.

[CarlosAMonroy]

Hi,

I guess it is easy than it seems. You can add the following:

Sum({1-$}Amount)

Hope this helps!

Carlos