Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

How to get the Line axis in my Scattered chart ?

Hello,

I have the scattered chart as shown below;

Project_number, Project_Name, Region, Country_Name as Dimensions

Sold_Values, and Forecast_Values as Expressions

Sold_Values vs Forecast Values:

cap.PNG

How to get the reference line axis in the Scattered chart? (As shown below)

Desired Output:

Capture.PNG

thanks

Bhavesh

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I was thinking of something like this

2018-09-27 23_03_02-Window.png

View solution in original post

8 Replies
vishsaggi
Champion III
Champion III

May be here?

Capture.PNG

bhaveshp90
Creator III
Creator III
Author

I tried to do that with the expression (GMP as Forecasted/GMP as Sold) in the reference lines. But this is what I am getting (I posted the desired output in my question now)

123.PNG

vishsaggi
Champion III
Champion III

Can you share a sample file to look into please?

bhaveshp90
Creator III
Creator III
Author

I tried doing so, how can I attach the file here ???

swuehl
MVP
MVP

Maybe like discussed here

Scatter plot with diagonal reference line

bhaveshp90
Creator III
Creator III
Author

Considering x as your only dimension you have this expression;

=aggr(NORMINV( 1-(rank(x)  - 0.5) / count(distinct total ) , 0,1),x)

But I am having Project_number, Project_Name, Region, Country_Name as Dimensions in my scattered chart.


What changes should I make in the expression?

swuehl
MVP
MVP

I was thinking of something like this

2018-09-27 23_03_02-Window.png

bhaveshp90
Creator III
Creator III
Author

Perfect 🙂 thank you for the answer