Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

How to set % on right side of chart and left side display sales and target ?

Hi All

I try to add a % line to display % gap on sales vs target , my expression is working fine , but i am not able to make the % line appear on the chart .


rangesum(above(
sum({$<year = {$(=max({<sales = {'*'}>}year))}, month = {"<=$(=max({<year={$(=max({<sales = {'*'}>}year))}>} month))"}>} sales)/1000
,0,rowno())) /
rangesum(above(
sum({$<year = {$(=max({<sales = {'*'}>}year))}, month = {"<=$(=max({<year={$(=max({<sales = {'*'}>}year))}>} month))"}>} sales_target)/1000
,0,rowno())) -1

May i know how to make the red line % line display on the right size of the chart , now is using left side , wrong scale .

in my next post i will send my QS Doc

Paul

1 Solution

Accepted Solutions
paulyeo11
Valued Contributor II

Re: How to set % on right side of chart and left side display sales and target ?

Hi All

I just found the solution , i change the chart to combo , and i set the % line as secondary axis.

Now it look great.

Paul

1 Reply
paulyeo11
Valued Contributor II

Re: How to set % on right side of chart and left side display sales and target ?

Hi All

I just found the solution , i change the chart to combo , and i set the % line as secondary axis.

Now it look great.

Paul

Community Browser