Bar chart with constant straight line

[Qlik_Bio06]

Hello everyone

I would like to show the following facts in a bar chart:
Only orders add up from 1.-15. received in the month. How do I do this with a function? Light Blue
The order volume is then accumulated again. Dark blue
How do I add a constant straight line to the chart. Value 2.2 million yellow.

How do I get the months displayed in the X-axis?

I would appreciate any help.

Greetings

Ebi

[PradeepK · Accepted solution]

use Month() function to derive Months from Date Field

Go to  Add-ons -> Reference Line section to add reference lines.