topic Re: Show only 2 values in pie chart in QlikView https://community.qlik.com/t5/QlikView/Show-only-2-values-in-pie-chart/m-p/1029743#M946368 <HTML><HEAD></HEAD><BODY><P>It worked! Thank u a lot!</P></BODY></HTML> Tue, 05 Jan 2016 17:31:59 GMT 2016-01-05T17:31:59Z Show only 2 values in pie chart https://community.qlik.com/t5/QlikView/Show-only-2-values-in-pie-chart/m-p/1029741#M946366 <HTML><HEAD></HEAD><BODY><P>Hi guys! </P><P></P><P>I have a problem. In my pie chart there are 4 values: 'Yes', 'No', 'Null' and 'Maybe'.</P><P></P><P>I wanna show only <STRONG>'Yes'</STRONG> and <STRONG>'No'</STRONG> values. How can I hide the other 'Null' and 'Maybe' values from this chart? Is there <SPAN style="font-size: 10pt; line-height: 1.5em;">a special formula I could use?</SPAN></P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 05 Jan 2016 17:24:37 GMT https://community.qlik.com/t5/QlikView/Show-only-2-values-in-pie-chart/m-p/1029741#M946366 2016-01-05T17:24:37Z Re: Show only 2 values in pie chart https://community.qlik.com/t5/QlikView/Show-only-2-values-in-pie-chart/m-p/1029742#M946367 <HTML><HEAD></HEAD><BODY><P>In your expression add this as a set analysis:</P><P></P><P><STRONG>Count(<SPAN style="color: #ff0000;">{&lt;FieldName = {'Yes', 'No'}&gt;}</SPAN>FieldName)</STRONG></P></BODY></HTML> Tue, 05 Jan 2016 17:27:51 GMT https://community.qlik.com/t5/QlikView/Show-only-2-values-in-pie-chart/m-p/1029742#M946367 sunny_talwar 2016-01-05T17:27:51Z Re: Show only 2 values in pie chart https://community.qlik.com/t5/QlikView/Show-only-2-values-in-pie-chart/m-p/1029743#M946368 <HTML><HEAD></HEAD><BODY><P>It worked! Thank u a lot!</P></BODY></HTML> Tue, 05 Jan 2016 17:31:59 GMT https://community.qlik.com/t5/QlikView/Show-only-2-values-in-pie-chart/m-p/1029743#M946368 2016-01-05T17:31:59Z