topic How to rename my Pie-Chart Values? in QlikView

How to rename my Pie-Chart Values?

Thu, 18 Dec 2014 04:45:46 GMT

I need to rename

D as Hold

B as Released

A as Shipped

Pls help !!

Re: How to rename my Pie-Chart Values?

amit_saini — Thu, 18 Dec 2014 04:59:40 GMT

Hi ,

Use

load * Inline [

Sort_code , New_Sort_code

A , Shipped

B, Released,

D,Hold

];

and call New_Sort_Code in chart.

Thanks,

Re: How to rename my Pie-Chart Values?

amit_saini — Thu, 18 Dec 2014 05:18:02 GMT

Second option is :

Wild-match Function

LOAD *

pick( WildMatch(Your_Field ,'*A*','*B*','*D*'),'Shipped','Released','Hold')

From

.....

Thanks,

;

Re: How to rename my Pie-Chart Values?

Thu, 18 Dec 2014 05:29:26 GMT

Hi Amit,

You are Awesome man! thank you

Re: How to rename my Pie-Chart Values?

amit_saini — Thu, 18 Dec 2014 05:31:31 GMT

Happy to help u buddy

Thanks,

Re: How to rename my Pie-Chart Values?

Thu, 18 Dec 2014 05:50:13 GMT

hi amit.....can u plz tell me how to call a function (New_Sort_Code ) in chart

Re: How to rename my Pie-Chart Values?

amit_saini — Thu, 18 Dec 2014 05:56:48 GMT

Kapil,

pick( WildMatch(Your_Field ,'*A*','*B*','*D*'),'Shipped','Released','Hold') as New_Sort_Code

You have to use this function within the same table of your field , later call this new field as expression in your chart.

Thanks,

Re: How to rename my Pie-Chart Values?

prma7799 — Thu, 18 Dec 2014 05:59:05 GMT

Hi Amit,

I did pie chart like above but unable to show values on front of sort code.

Please help.

Thanks,

Prashant

Re: How to rename my Pie-Chart Values?

amit_saini — Thu, 18 Dec 2014 06:03:18 GMT

Hi,

You need to call in expression as Count(New_Sort_Value)

Thanks,

Re: How to rename my Pie-Chart Values?

Thu, 18 Dec 2014 06:08:30 GMT

Hi team,

See my Screen shorts.

Re: How to rename my Pie-Chart Values?

prma7799 — Thu, 18 Dec 2014 06:15:38 GMT

Hi,

I done with these from show numbers in legend no need to add Count(New_Sort_Value) in expression.

Now I want the percentage values with original value like above

Thanks,

Prashant

Re: How to rename my Pie-Chart Values?

Thu, 18 Dec 2014 06:20:08 GMT

Hi Prashant,

In Expression click on Relative. you will get percentage.

Re: How to rename my Pie-Chart Values?

prma7799 — Thu, 18 Dec 2014 06:26:07 GMT

Hi Murali,

I need percentage and rear values also.

Thanks,

Prashant

Re: How to rename my Pie-Chart Values?

Thu, 18 Dec 2014 06:28:25 GMT

Hi Prashant,

If you want Dual value to be displayed then pls try this.

dual(NUM(SUM(Expression1)/SUM(Total Expression1), '#,##0%') & ' / ' & Num(SUM(Expression1), '#,##0'), Num(SUM(Expression1), '#,##0'))