Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paulkraemer
New Contributor II

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
Esteemed Contributor

Re: Marking points of interest on a line chart

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

3 Replies
omarbensalem
Esteemed Contributor

Re: Marking points of interest on a line chart

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
Honored Contributor II

Re: Marking points of interest on a line chart

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

paulkraemer
New Contributor II

Re: Marking points of interest on a line chart

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?