Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Others legend value not displaying when value is null in the Pie Chart

I'm using Pie chart and  i done the following expression in my qlikview.

I am not getting others category in pie chart but, while i'm using Straight table it shows the Others and it's count.

what is the problem in my expression.

Expression :

if(IsNull([Customer]), 'Others' ,  Count({<[Category] -= {'*ISSUE PASS*'}>}DISTINCT [Customer])).

Labels (3)
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

By adding a calculated dimension like: =if(len(trim(dim))=0,'Others',dim)

Attached Qv for reference

View solution in original post

6 Replies
Highlighted
Specialist II
Specialist II

Could you share the sample application

Highlighted
Creator
Creator

pls. find the screenshot for reference...

Highlighted
Specialist II
Specialist II

Check show all values in Dimension  tab as seen in the attached

Highlighted
Creator
Creator

Thanks...If something is blank or null or - then the legend should update as "others"..
How do i do this...?
Highlighted
Specialist II
Specialist II

By adding a calculated dimension like: =if(len(trim(dim))=0,'Others',dim)

Attached Qv for reference

View solution in original post

Highlighted
Creator
Creator

Excellent...It's working...Thanks...