topic Re: Pie Chart- how to change given data name to another name? in QlikView

Pie Chart- how to change given data name to another name?

jim_chan — Wed, 10 Oct 2018 02:46:38 GMT

Hi guys,

I have created a pie chart and added sample data in it. - as per attached qvw.

my scenario, the i have a category column, showing A and B data. But at the font end(visual), user would want to replace the data A name to another name, for exmaple: change A to Vegetable, B to Meat.

So, how can i do that at the front end, in the pie chart properties?

Re: Pie Chart- how to change given data name to another name?

Anonymous — Wed, 10 Oct 2018 02:59:47 GMT

Hi,

Use "Pick match " function or "If" condition

"=pick(Match(Category,'A','B'),'Vegetable','Meat')" or

"if(Category='A','Vegetable',

if(Category='B','Meat'))"

Re: Pie Chart- how to change given data name to another name?

Sergey_Shuklin — Wed, 10 Oct 2018 05:00:45 GMT

Hello!

If you have fixed number of categories you can use input box objects that will allow user to define aliases for the categories.

Also you'll have to add a variable for each value of the category field.

Re: Pie Chart- how to change given data name to another name?

Anonymous — Wed, 10 Oct 2018 05:14:34 GMT

Hi Jim,

You can rename at back-end script or you can use pick and match combination at front-end using Inline table.

Thanks and regards,

Yogendra W.

Re: Pie Chart- how to change given data name to another name?

chinnuchinni — Wed, 10 Oct 2018 05:26:06 GMT

Hi Jim,

As @ yogendra said,if you have fixed number of dimension values,you can use pick & match function in dimension , like below.

Dim:

=pick(match(Year,'2016','2017','2018'),'Yellow','Red','Blue')

Exp:

=sum(revenue)

Re: Pie Chart- how to change given data name to another name?

jim_chan — Wed, 10 Oct 2018 06:34:50 GMT

Hi Yogendra,

how to write at the back end script??? is it same as =pick(match(Year,'2016','2017','2018'),'Yellow','Red','Blue') ??

rgds

Jim

Re: Pie Chart- how to change given data name to another name?

Anonymous — Wed, 10 Oct 2018 06:40:02 GMT

Hi Jim,

This script would work.

Thanks and Regards,

Yogendra W.

Re: Pie Chart- how to change given data name to another name?

chinnuchinni — Wed, 10 Oct 2018 07:05:52 GMT

Hi,

LOAD Year,

Project,

Employee,

Hours,

pick(match(Year,'2016','2017','2018'),'Yellow','Red','Blue') as Color

FROM XXXX ;

Dim:

Color

Exp:

sum(REvenue)

Re: Pie Chart- how to change given data name to another name?

jim_chan — Wed, 10 Oct 2018 07:14:09 GMT

Hi sergey,

Thanks for your effort , although this is not what the user is expecting.... However, is great to know it can be done such a way, at least i can provide an option for the users to choose.

Thanks Sergey, i will definitely share it with my users.

Rgds

Jim