X and Y axis on chart.

[#1]

Hello Experts,

I have one requirement I want to create chart with 2 axis.

for x axis i want values and on y i want growth.

Please see the attachment .

Thanks

[rubenmarin]

Hi, you can set the left or right axis for each expression in the Axis tab:

[gautik92]

create 2 expression may be second with growth go to axis tab select growth expr and select left option

[#4]

Hi Gowtham,

Can you please send me some sample qvw for the same.

Thanks

[gautik92]

Have a look at this

[#6]

Hi Gowtham,

Thanks but this is not which am looking for.

I want sum(sale) on Xaxis and Growth line on Yaxis.

Growth formula is

(sum(sale) - last year sum(sale))

/

last year sum(sale))

*100

Thanks

[gautik92]

replace target with growth thats t

[#8]

Gowtham,

PFA...

Can you give me right solution on my qvw.

In that application i already achieve values but am not able to get growth .

Thanks

[gautik92]

Have a look at this

[gautik92]

if you got the answer mark it as correct and close the thread