Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Changing the names of the x axis entries

Hi everyone,

I'm fairly new to Qlikview and currently stuck on a problem I just can't seem to solve. Despite searching via google and on here, I did not find any information on what I'm trying to do.

I have a pretty simple bar graph which uses a table called 'orders' and counts the orders per article type. So the formula for the graph is 'count(orderid)' whereas my dimension is 'articletype'. Now the field articletype in the 'orders' table is an integer (1-8), referencing the table 'articletype' which, among other fields, contains the name of the article type. The columns in the graph are thus called 1, 2, 3 and so on. I'd like to display the name of the article type instead, so I inner-joined the corresponding table and field.

Now I simply don't know where to go from here. I thought I'd have to use the label field in the dimension tab, but the only thing that does is change the label of the x axis as a whole, not the names of its fields. I just can't seem to find where I need to go in order to change the labels of the x axis columns. Any help with this would be greatly appreciated.

Thanks in advance,

Aaron

1 Solution

Accepted Solutions
Employee
Employee

Re: Changing the names of the x axis entries

Use description as dimension instead of articletype.

4 Replies
MVP & Luminary
MVP & Luminary

Re: Changing the names of the x axis entries

Hi,

Can you attach the scripts you used or attach sample file which you are working.  It helps in understanding the problem.

Regards,

Jagan.

Not applicable

Re: Changing the names of the x axis entries

The following are the relevant fields in the two tables.

table 'orders'

orderid
articletypeand so on...
12101...
22201...

table 'articletype'

articletypedescription
2101microwave
2201bicycle

I want to display microwave instead of 2101 and bicycle instead of 2201 and so on underneath the bars in the graph. I attached the qvw file I use.

Employee
Employee

Re: Changing the names of the x axis entries

Use description as dimension instead of articletype.

Not applicable

Re: Changing the names of the x axis entries

Tried that before and it screwed up the numbers, but now it works for some reason. Don't really know what I changed since I last tried. Thanks for helping me.

Community Browser