Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

How to Rename The Legend

Hi Have Created a Pie Chart.

There i have 4 catogiries and one catogory is null.

I want to display all catogories in the chart.

So in my legend the null value shows as "-".

I need to rename that value as "NOT Recived".

Please help me to do this.

Thanks

1 Solution

Accepted Solutions
thomas_skariah
Creator III
Creator III

Hi Anu,

Find the attached application,you will get an idea.

Regards,

Tom

View solution in original post

6 Replies
fdelacal
Specialist
Specialist

if category contains all categories the  5 you write in the expression

if(catogory ='-', 'NOT Recived',catogory)

if category only contains '-' write

if(catogory ='-', 'NOT Recived')

anuradhaa
Partner - Creator II
Partner - Creator II
Author

please tell me where to put that expression in PIe chart.

my four catogories are,

Recive with Accept

Recived with reject

Recived with Data Change

Ricived with Errors

and "-" - I want to display this as "NOt Recived"

fdelacal
Specialist
Specialist

which are your dimension and you expression??

thomas_skariah
Creator III
Creator III

Hi Anu,

Find the attached application,you will get an idea.

Regards,

Tom

anuradhaa
Partner - Creator II
Partner - Creator II
Author

Hi This works fine , Thanks.

But There is a Problem.

I can't clik on "NOt Recived" are and filler the data.

Please help.

Thanks

MayilVahanan

Hi

Try in script, then

You need that one chart or more than that, if more than one means,

Load *, if(isnull(FieldName)=-1,'NotReceived',FieldName) as FieldName from tablename;

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.