Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sunainapawar
Creator
Creator

Show Nulls as Others in Pie Chart

Hello,

I have to show Null Values in Pie Chart as 'Others'.  I tried with Fixed Number, Exact value and Relative Value. However, relative value works somehow when i give >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.

I have used below expression in Pie chart. 

Is there any other way to do this.

Count( {1<card_fYear={"<=$(vMaxYear)"},card_status={'ACTIVE'}>} distinct customer_id)

Please suggest.

 

Labels (1)
0 Replies