4 Replies Latest reply: Jul 9, 2012 7:37 AM by aaronaar RSS

    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