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: 
Anonymous
Not applicable

Marking points of interest on a line chart

Hello everyone,

I made a line chart, which shows two graphs, with the x-axis being date, and y-axis a price.

Now i want to mark 9 specific points on one of the graphs, with specific dates and the same price. Optimally the markings would also show up in the legend.

Basically, it should look similar to the following picture:

Stadtwerke Preisentwicklung Grafik.PNG

The points i want to mark now are the "Tranchenkäufe", marked with a red dot on the blue line.

I also have the Extension "dygraphs" installed, if this could help.

Thank you,

Paul

1 Solution

Accepted Solutions
OmarBenSalem

Maybe you should use a combined chart instead of a line chart.

Capture.PNG

put your current expression as a line:

Capture.PNG

and your new expression (where you focus on ur 9 dates)  as points.

Capture.PNG

let's say in my example I want to focus on the LAST 15 DAYS:

I have to do as follow (with the if)

if(sum({<AsOf_Date={">$(=max(AsOf_Date)-15)"}>}[Net (Euro)])=0,

null(),

sum({<AsOf_Date={">$(=max(AsOf_Date)-15)"}>}[Net (Euro)]))

so, you have to do as me:

if(YourNewMeasure=0, null(),YourNewMeasure)



Result:

Capture.PNG

View solution in original post

3 Replies
OmarBenSalem

Maybe you should use a combined chart instead of a line chart.

Capture.PNG

put your current expression as a line:

Capture.PNG

and your new expression (where you focus on ur 9 dates)  as points.

Capture.PNG

let's say in my example I want to focus on the LAST 15 DAYS:

I have to do as follow (with the if)

if(sum({<AsOf_Date={">$(=max(AsOf_Date)-15)"}>}[Net (Euro)])=0,

null(),

sum({<AsOf_Date={">$(=max(AsOf_Date)-15)"}>}[Net (Euro)]))

so, you have to do as me:

if(YourNewMeasure=0, null(),YourNewMeasure)



Result:

Capture.PNG

ogster1974
Partner - Master II
Partner - Master II

If you want to draw users attention to specific insights on a chart have you considered taking a snapshot and creating a data story?

Anonymous
Not applicable
Author

Hello,

thanks for your response, i got it to work.

Only problem left now is, that the marked points are way to small and barely recognizable, because the x-axis has a lot of dates, and i couldnt find an option to increase the size. any suggestions?