topic Re: How to Rename The Legend in QlikView

How to Rename The Legend

anuradhaa — Tue, 30 Oct 2012 09:58:32 GMT

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

fdelacal — Tue, 30 Oct 2012 10:06:56 GMT

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 — Tue, 30 Oct 2012 10:13:17 GMT

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 — Tue, 30 Oct 2012 10:23:03 GMT

which are your dimension and you expression??

thomas_skariah — Tue, 30 Oct 2012 10:39:14 GMT

Hi Anu,

Find the attached application,you will get an idea.

Regards,

Tom

anuradhaa — Tue, 30 Oct 2012 13:02:46 GMT

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 — Tue, 30 Oct 2012 13:09:36 GMT

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