Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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