Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])).
By adding a calculated dimension like: =if(len(trim(dim))=0,'Others',dim)
Attached Qv for reference
Could you share the sample application
pls. find the screenshot for reference...
Check show all values in Dimension tab as seen in the attached
By adding a calculated dimension like: =if(len(trim(dim))=0,'Others',dim)
Attached Qv for reference