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

Trying to change x-axis label on chart based on key

So basically I want a chart that follows the x axis but for x axis labels I need it to say the product associated with the axis:

Untitled.png

The axis needs to follow x but the labels should be advocacy where x is 54, 59.5 and 65. Task Force at 27, 46, 65, etc
Thanks!
1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_140026_Pic1.JPG.jpg

QlikCommunity_Thread_140026_Pic3.JPG.jpg

QlikCommunity_Thread_140026_Pic2.JPG.jpg

using

=Dual(Product1, X)

rather than

=Aggr(Product1, X)

hope this helps

regards

Marco

View solution in original post

8 Replies
MarcoWedel

Calculated Dimension:

Aggr(Product1, X)

Not applicable
Author

“No Numeric Value on X axis” is what it tells me.

JonnyPoole
Employee
Employee

perhaps you have a continuous X axis enabled on the presentation tab  ?

personally i'm not sure, i'd like to see a QVW sample.

Not applicable
Author

I got rid of the continuous axis and that error doesn't show up but all my data points are pooling in one area and it shows null for x while aggr my product1 with it. I wish I could show you the qvd but the data is rather sensitive. I'm doing an associative curve chart.

JonnyPoole
Employee
Employee

can you screenshot the result without the yaxis ?  a qvw would still help

MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_140026_Pic1.JPG.jpg

QlikCommunity_Thread_140026_Pic3.JPG.jpg

QlikCommunity_Thread_140026_Pic2.JPG.jpg

using

=Dual(Product1, X)

rather than

=Aggr(Product1, X)

hope this helps

regards

Marco

Not applicable
Author

I actually figured this out myself yesterday! But I will give you the correct answer anyway! Thank you

Not applicable
Author

Now if there was a way I could use a continuous X axis so things don't look so skewed!...