topic Re: Change the axis in QlikView

Change the axis

iliaisyah — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Change the axis

anushree1 — Mon, 28 Jan 2019 07:17:38 GMT

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.

Re: Change the axis

iliaisyah — Mon, 28 Jan 2019 07:51:46 GMT

it didnt work

if in excel it will look like in the excel

my data compilation as attached

Re: Change the axis

anushree1 — Mon, 28 Jan 2019 08:09:15 GMT

It can be done as per this solution.

Re: Change the axis

anushree1 — Mon, 28 Jan 2019 08:09:45 GMT

Re: Change the axis

iliaisyah — Mon, 28 Jan 2019 09:06:53 GMT

i have open the file

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

Re: Change the axis

anushree1 — Mon, 28 Jan 2019 09:07:18 GMT

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

Re: Change the axis

anushree1 — Mon, 28 Jan 2019 09:12:30 GMT

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