Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Ludvig
Contributor II
Contributor II

Line chart and multiple values

In a line chart with datetime dimension on the x axis, data sometimes has multiple values for the same second. Hence no points are visible in chart for that very datetime value.
Is there a way to force QS to draw all values or any workarounds you can recommend?

2 Replies
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Ludvig,

 

The way a line chart usually works is to only show you one measure value per dimension value.

Aka -> Avg Stock price per date for example - in reality the price changed multiple times but you usually only want to see the market exit price in a line chart (last price).

You need to understand what operation makes most sense according to your data.

 

Is it Sum(ExpressionValue) -> if for example you are analyzing sales per date

Or is it Max(ExpressionValue) / Min(ExpressionValue) -> if you are interested in the extremums

Or is it Avg(ExpressionValue) -> if you want to know the average between all points at that date

 

 

I hope that helps!

Kind regards,

S.T.

Ludvig
Contributor II
Contributor II
Author

Thanks!

I was expecting that answer and will use suitable "workarounds".