Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
saivina2920
Contributor

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])).

1 Solution

Accepted Solutions
anushree1
Valued Contributor

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

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

Attached Qv for reference

6 Replies
anushree1
Valued Contributor

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

Could you share the sample application

saivina2920
Contributor

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

pls. find the screenshot for reference...

anushree1
Valued Contributor

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

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

saivina2920
Contributor

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

Thanks...If something is blank or null or - then the legend should update as "others"..
How do i do this...?
anushree1
Valued Contributor

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

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

Attached Qv for reference

saivina2920
Contributor

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

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