https://community.qlik.com/t5/App-Development/Show-Nulls-as-Others-in-Pie-Chart/m-p/1688848#M52568 <P>Hello,</P><P>I have to show Null Values in Pie Chart as 'Others'.&nbsp; I tried with Fixed Number, Exact value and Relative Value. However, relative value works somehow when i give &gt;1.0%, But there are some customer types where value is less than 1.0%. When i give 1.0% those values are also getting included in 'Others'. I dont want them to be included in Others.</P><P>I have used below expression in Pie chart.&nbsp;</P><P>Is there any other way to do this.</P><P>Count( {1&lt;card_fYear={"&lt;=$(vMaxYear)"},card_status={'ACTIVE'}&gt;} distinct customer_id)</P><P>Please suggest.</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:52:16 GMT sunainapawar 2024-11-16T18:52:16Z https://community.qlik.com/t5/App-Development/Show-Nulls-as-Others-in-Pie-Chart/m-p/1688848#M52568 <P>Hello,</P><P>I have to show Null Values in Pie Chart as 'Others'.&nbsp; I tried with Fixed Number, Exact value and Relative Value. However, relative value works somehow when i give &gt;1.0%, But there are some customer types where value is less than 1.0%. When i give 1.0% those values are also getting included in 'Others'. I dont want them to be included in Others.</P><P>I have used below expression in Pie chart.&nbsp;</P><P>Is there any other way to do this.</P><P>Count( {1&lt;card_fYear={"&lt;=$(vMaxYear)"},card_status={'ACTIVE'}&gt;} distinct customer_id)</P><P>Please suggest.</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:52:16 GMT https://community.qlik.com/t5/App-Development/Show-Nulls-as-Others-in-Pie-Chart/m-p/1688848#M52568 sunainapawar 2024-11-16T18:52:16Z