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: 
iliaisyah
Contributor III
Contributor III

Change the axis

Hai and good afternoon,

enclosed is the graph that i have.

how can i change my Y axis to X axis. 

I wish to have month to X axis and Elements in Axis Y.

But the expression is the monthly yield per area basis 

the graphs is Location Yield per area

Picture1.png

1 Solution

Accepted Solutions
anushree1
Specialist II
Specialist II

Well you may skip the group by and sum , but concatenate and as keyword are essential,like the attached

View solution in original post

7 Replies
anushree1
Specialist II
Specialist II

Hi, 

I am not sure if this is the answer you are looking for, whatever you put up on Dimension Tab of a chart becomes your X Axis and the Expression your Y Axis , if you have added Month as Dimension in Dimension Tab you should already be seeing it on X: Axis, Please provide the sample qvw if you are looking for something in specific.

iliaisyah
Contributor III
Contributor III
Author

it didnt work

if in excel it will look like in the excel

my data compilation as attached

anushree1
Specialist II
Specialist II

It can be done as per this solution.

anushree1
Specialist II
Specialist II

 
iliaisyah
Contributor III
Contributor III
Author

i have open the file

is they other way that i can use just from the chart function and not the editting the script?

anushree1
Specialist II
Specialist II

You could also try this method as its much cleaner than the previous solution provided

anushree1
Specialist II
Specialist II

Well you may skip the group by and sum , but concatenate and as keyword are essential,like the attached