topic Re: Pie charts - group by other in QlikView

Pie charts - group by other

Mon, 14 Sep 2015 09:21:22 GMT

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

Re: Pie charts - group by other

qlikmsg4u — Mon, 14 Sep 2015 09:44:22 GMT

Hi kierankeene,

PFA solution, Credits to jason.michaelides

Re: Pie charts - group by other

Mon, 14 Sep 2015 09:53:23 GMT

Hi,

K N is correct follow his example.

Re: Pie charts - group by other

Mon, 14 Sep 2015 09:55:06 GMT

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

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:00:44 GMT

Hi,

Use this expression in the expression tab,

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

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:05:56 GMT

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?

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:15:18 GMT

Hi,

try this.

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

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

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:17:22 GMT

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

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:18:26 GMT

Oh sorry, I see what you mean.

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

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:19:35 GMT

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

Thanks

Harshitha

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:21:19 GMT

I think that bit now works ,.... phew! I forgot the '=' sign off your suggestion.

Thank you for all the help!!

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:26:12 GMT

Great it worked as you want

Thanks

harshitha

Re: Pie charts - group by other

Mon, 14 Sep 2015 10:26:22 GMT