Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Master
Master
Author

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

View solution in original post

1 Reply
paulyeo11
Master
Master
Author

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