Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
gsan
Contributor II
Contributor II

Scatter Plot - connect dots (or) can it be replaced by line chart?

Hi guys,

I have created a scatter plot, but I would like to join the dots by 'product' based on date.

I have attached a sample file. Is it possible to connect all 'G9' through a line and 'P23' by a line?

Is it possible to achieve the same result using line chart, because I would like to change the x axis to date, month, quarter, year ?

Ex: ID: 1086 and 1088 falls on the same date, but in the line chart I don't want to aggregate and it should be at ID level, even if I change it to month, Quarter etc?

Thanks

Sam

Labels (3)
2 Replies
tommyl
Creator
Creator

Hello,

I guess instead of scatter plot, you need combo chart. Or scatter plot without linking the dots. 

Regards,

T. 

 

gsan
Contributor II
Contributor II
Author

Hi Tommy, Thank you for your reply. If Scatter plot is not possible, then i need to use Line chart, because i have 2 dimensions. 

I have attached the screen shot.
In scatter plot, I have used
Dimesion: ID
X-axis: Avg((DOM)). This is a date field.
Y-Axis: Avg(If([metric_type] = 'aal1', (result_value)))
Color: Product name

If i can replace it with line/combo chart, then I need to use 2 dimension and 1 measure
1) Dimension - Date, Product
2) Measure - Result_value. This shouldn't be aggregated at date level, but need to see at ID level.
What should be measure expression if i need the level of detail at ID level?