Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Replacing numbers with text on the y-axis of a bar chart

Hi


I have  a bar chart which currently shows the numeric values we have assigned to specific grades of staff - however, I want to change this so that the y-axis shows the grade title of the staff rather than the grade value which we have created.

I entered the following in the Load Script but can't seem to be able to change the y-axis to the titles.

REPLACE LOAD

dual(Text,Number) as Grade

INLINE [

Text,Number

Partner,10

Director,9

Senior Manager,8

Manager,7

Senior Associate 3,6

Senior Associate 2,5

Senior Associate 1,4

Associate 2,3

Associate 1,2

Support,1

];

Not sure what the issue is. Any help would be appreciated. I summarise the titles and values below.

Value -  Title

10 - Partner

9- Director

8 -Senior Manager

7- Manager

6- Senior Associate 3

5 - Senior Associate 2

4- Senior Associate 1

3- Associate 2

2- Associate 1

1- Support,

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

As far as I know what you want is not possible. The values on the y-axis cannot be mapped to string values.


talk is cheap, supply exceeds demand
Highlighted
Champion III
Champion III

Can't you simply use the Title field as chart dimension?

Highlighted
Not applicable

No I have something else as the dimension.

snippet.PNG.png

In place of the digits on the y-axis, I want to have  grades Support > Associate 1 > Associate 2 etc.