Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Looking to filter data out of a pie chart.

Hello,

I am currently working on creating a pie chart.  To simplify things the pie chart has 4 parts. Lets call them 1,2,3,4.  1 and 2 are from category A. and 3,4 are from Category B. I want to filter out category A so that the pie chart will only show the percentages of 3,4 rather than all 4.  Essentially its like saying in a table show me all rows where Column 1 = A and not rows where Column 1 = B. But I want to do this in graph as the sheet loads and not have a user have to click on the tab to filter on their own.

The expression I am using now is as follows:     Count(IF (Name = 'A',Field,0))   

With this I am hoping to only have the graph do a count of the rows where the data matches what I want and for the data I don't want have it count as 0 so it wont show up.  This does not seem to make any difference when it updates.

I am happy to answer any further questions.

 

Thank you,

 

Labels (3)
3 Replies
Highlighted
Employee
Employee

Count({<Name = {A}>}Field)
Highlighted
Contributor III
Contributor III

I am seeing "The chart is not displayed because it contains only negative or zero values." I'm assuming this may be saying it filtered out all results?

 

 

Highlighted
Specialist II
Specialist II

Count({<Name={'A'}>} Field)

Yes, the message indicates the filter yields no positive values.