topic How to rename column label? in QlikView

How to rename column label?

Fri, 02 Apr 2010 15:24:12 GMT

Hi,

Is it possible to rename column legend?

For example, in the bar chart attached, i would like to be able to rename the last column legend.

Thanks.

How to rename column label?

Sat, 03 Apr 2010 18:57:11 GMT

Not sure if this is what you want, but you can edit the dimension Product to make it a calculated dimension.

For instance


=if(Product='Product6', 'Other name',Product)

Of course you can use a variable or an expression that results in a string instead of 'Other name'.

How to rename column label?

rwunderlich — Tue, 06 Apr 2010 03:12:22 GMT

Mark,

Great suggestion!

-Rob

How to rename column label?

Tue, 06 Apr 2010 11:07:38 GMT

Ok. But I would like to apply this renaming to the last column, whatever its content is (not only for "Product6").

For instance, I already tried to use the "rowno()" function to identify the last column (within the same kind of calculated dimension you proposed) but that's not working (the row identification is certainly made after the column display).

The idea behind is that i would like to do some kind of "Others" column to aggregate the remaining total in the last column when the max visible number of rows is limited. I know there is a way with Aggr() function but the problem is that using Aggr() in calculated dimension prevent to sort values correctly in chart. And I need to keep the ability to sort values.

How to rename column label?

Wed, 07 Apr 2010 09:48:38 GMT

hi,

you can use the following

=if(Product=fieldvalue('Product',fieldvaluecount('Product')),'namechange',Product)

as a calculated dimension in your chart.

thanks

How to rename column label?

Wed, 07 Apr 2010 12:24:57 GMT

Hi,

That's interesting but I need to have the last column renamed. With columns sorted descending, this renames 'Product6' but not the last one which is 'Product4' here.

How to rename column label?

Wed, 07 Apr 2010 13:56:39 GMT

hi,

what u can do first is find min(Sales) as minimumsales in your script and use the following

if(Sales=minimumsales , 'namechange',Product)

i think this should work fine now

thanks

How to rename column label?

Wed, 07 Apr 2010 13:57:50 GMT

hi,

what u can do first is find min(Sales) as minimumsales in your script and use the following

if(Sales=minimumsales , 'namechange',Product) as a calculated dimension in your chart

i think this should work fine now

thanks