topic Re: Replace dimension values names in object properties in QlikView

Replace dimension values names in object properties

Mon, 23 Sep 2013 17:11:54 GMT

I have one column named Company with all the values in the column equal to zero (no matter sens of that).

When I create a chart displaying sum of all records with Company = 0 (just one bar) the label of the bar is 0. I would like to change it to something else (e.g. 'zero') but from an object level (not script). Is there a way to do it?

Re: Replace dimension values names in object properties

manas_bn — Mon, 23 Sep 2013 17:27:17 GMT

Hello,

Instead of adding "Company" as a dimension, add a Calculated Dimension:

=if(Company='0','Zero',Company)

Change the label to Company

Hope this helps!

Manas

Re: Replace dimension values names in object properties

gopalopsharma — Mon, 23 Sep 2013 17:54:16 GMT

Hello,

We can change the Label of Any dimension or expression from the object properties. If you do not want anything then give a space.

This label is displayed below/ aside the Axes.

If my understanding is correct then the 0 which is appearing at the top of the Bar is the data value..

If you want to remove this then

Go to object properties
Go to Expressions tab
Uncheck the "Values on data points" box present in the middle bottom
Also since it is the value so it can not be changed

Please let me know if anything else is required.

Re: Replace dimension values names in object properties

MayilVahanan — Mon, 23 Sep 2013 18:14:48 GMT

add a Calculated Dimension:

=if(Company='0','Zero',Company)

or in script

Load if(Company='0','Zero',Company) as Company from tablename;