Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.