topic Re: removing specific fields in a pie chart? in QlikView

removing specific fields in a pie chart?

knightwriter — Fri, 20 Nov 2020 18:02:30 GMT

Hi friends,

How do I remove a specific activity type from my pie chart? Thanks.

anguila — Mon, 23 Mar 2015 16:29:42 GMT

You could remove it from your dimension.

So in the dimension tab:

if (Activity_Owner.BusinesGroup<>'IT',Activity_Owner.BusinesGroup)

Then check the supress when null value checkbox. Thus, you're choosing as your dimension everything but IT.

rubenmarin — Mon, 23 Mar 2015 16:30:27 GMT

Hi Stephen, you can use set analysis, ie:

TextCount({<Activity.Type-={"IT(Name of the activity to exclude)"}>} Activity.Type)

TextCount({<Activity_Owner.BusinesGroup-={"IT(Name of the activity to exclude)"}>} Activity.Type)

It will show an error on expression but it should work.

knightwriter — Mon, 23 Mar 2015 16:49:21 GMT

If I do more than 1 in the legend ie 2, it now shows the 2 fields that ive only excluded as opposed to the ones I want! What steps are next? Thanks.