Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change name dimension in bar chart

Hello everyone,

I need your help. Indeed, I want change a name to one dimension in bar chart :

tab6.PNG

I want change the name "-" in other name change color of the bar.

If you have any idea, tell me.

Thank you in advance.

Best regards

SD

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Change it to calculated Dimension

=IF(len(Fieldname)>0,Fieldname,'Others')

or preferably handle this during data load

example

LOAD

*,

IF(len(trim(Fieldname))>0,Fieldname,'Others') as Fieldname

From xxxx;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

7 Replies
ogster1974
Partner - Master II
Partner - Master II

To sort that out you have 2 choices

1. Click exclude null checkbox against your dimension which will remove it from your chart.

2 set a limitation on your dimension, fixed number (in your case 6) the rest of your values will then be shown as other.

Regards

Andy

ahaahaaha
Partner - Master
Partner - Master

Hi Salim,

As variant, may be, as in attached file. In this example, when loading the script, create an additional field X1. Next, in the chart, used X1 in place of X and adjust the color with the appropriate settings and expression. The color of the bar name could not change.

Regards,

Andrey

viveksingh
Creator III
Creator III

Hi Salim,

"-" is not name. the chart is holding null values. uncheck the "Show null values" option which will appear under the dimention.

OmarBenSalem

In your bar chart, under data, dimensions, uncheck this:

Capture.PNG

vinieme12
Champion III
Champion III

Change it to calculated Dimension

=IF(len(Fieldname)>0,Fieldname,'Others')

or preferably handle this during data load

example

LOAD

*,

IF(len(trim(Fieldname))>0,Fieldname,'Others') as Fieldname

From xxxx;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Hello,

No, I want to display the value when my dimension is equals null(), but I would name this field if it was possible.

Not applicable
Author

Thank you, it's the answer that I looked !