topic Re: X and Y axis on chart. in QlikView

X and Y axis on chart.

Thu, 15 Oct 2015 07:36:12 GMT

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 — Thu, 15 Oct 2015 07:41:20 GMT

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

gautik92 — Thu, 15 Oct 2015 07:41:24 GMT

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

Thu, 15 Oct 2015 09:14:56 GMT

Hi Gowtham,

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

Thanks

gautik92 — Thu, 15 Oct 2015 09:22:31 GMT

Have a look at this

Thu, 15 Oct 2015 09:32:20 GMT

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 — Thu, 15 Oct 2015 09:33:36 GMT

replace target with growth thats t

Thu, 15 Oct 2015 09:37:54 GMT

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 — Thu, 15 Oct 2015 09:57:45 GMT

Have a look at this

gautik92 — Thu, 15 Oct 2015 10:02:41 GMT

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