Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
Creator III

removing specific fields in a pie chart?

Hi friends,

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

pie chart.PNG

1 Solution

Accepted Solutions
anguila
Partner - Creator
Partner - Creator

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.

View solution in original post

3 Replies
anguila
Partner - Creator
Partner - Creator

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

Hi Stephen, you can use set analysis, ie:

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

or

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
Creator III
Creator III
Author

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.