Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

X and Y axis on chart.

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

9 Replies

Re: X and Y axis on chart.

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

gautik92
Valued Contributor III

Re: X and Y axis on chart.

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

Not applicable

Re: X and Y axis on chart.

Hi Gowtham,

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

Thanks

gautik92
Valued Contributor III

Re: X and Y axis on chart.

Have a look at this

Not applicable

Re: X and Y axis on chart.

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
Valued Contributor III

Re: X and Y axis on chart.

replace target with growth thats t

Not applicable

Re: X and Y axis on chart.

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
Valued Contributor III

Re: X and Y axis on chart.

Have a look at this

gautik92
Valued Contributor III

Re: X and Y axis on chart.

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

Community Browser