Pie charts - group by other

[#1]

Hi,

I wonder if you can help. Right now, if I select a company name in my dashboard, the pie chart is updated to show only that company value (like below).

What I would like to do, is be able to show 2 values in the pie chart. The value of the company that has been selected, along with the aggregated value of all other companies - simply marked as 'other'.

Is it possible to do this?

Thanks

[qlikmsg4u]

Hi kierankeene,

PFA solution, Credits to jason.michaelides

[#3]

Hi,

K N is correct follow his example.

[#4]

Thank you KN,

Unfortunately, I am still using the personal edition of QV (pending company sign off).

Therefore cannot open the file you sent.The field is called 'Sector' and the calculation is sum(pageviews),

Would you be able to help me out in here?

Thnks

[#5]

Hi,

Use this expression in the expression tab,

if(ValueList('$(=only(Sector))', 'Others') = 'Others',Sum({<Sector=E()>}pageviews),sum(pageviews)   )

[#6]

Thanks Harshitha,

I have added that to the expression field. My dimension is:

=ValueList('$(=only(sector))', 'Others')

However this does not help me filter

Do you know why?

[#7 · Accepted solution]

Hi,

try this.

=ValueList('$(=only('Sector'))', 'Others') as dimension and

if(ValueList('$(=only('Sector'))', 'Others') = 'Others',Sum({<Sector=E()>}pageviews),sum(pageviews)   )

[#8]

Thanks, I have put that all into the expression and removed my filter from the dimension - is that correct?

If so, I have an 'allocated memory exceeded' error

[#9]

Oh sorry, I see what you mean.

I have set the dimension and the expression and get "no data to display"

[#10]

You cant remove the filter in the dimension can you share your qvw file so that i can check it.

Thanks

Harshitha