Show a list of milsstones as positon lines on a bar chart

[SebastianRichter]

Dear experts,

I have a bar chart showing the period of a project. During that project there are several milesstones that don't follow a fixed structure, means the milesstone titles keep changing. I want to display all those milesstones as positon lines on this bar chart just as I did it with project start, project end and today.

The way it is now it only shows 1 (one) milesstone when I selected it. If I don't select any or select several, it doesn't show anything anymore.

Please support to show all these milesstones on the bar chart without having them selected before.

Many thanks in advance.

Best regards

Sebastian

[Antoine04]

Hello Sebastian,

Could you please share the sample of the DATA you are using ?

And tell me which chart are you using in your example ?

Thanks !

Antoine

[SebastianRichter]

Hello Antoine,

thanks for helping.

Attached are sample data as I use them. I'm using the standard bar chart that is available from QLIK Sense.
I also attach a pic of how I I wish it to look alike.

Best regards

Sebastian

[Antoine04]

Thanks,

On you barchart, can you also show me the dimension(s) and the measure(s) you are using please ? 

Regards,

Antoine

[SebastianRichter]

Hope this is what you need.

Dimension

CS order chargeable is the project number

Measures as Master Items

Gantt_Project_1 (white bar before start date)

[Basic start date.aC.Datum]

Gantt_Project_2 (grey bar between start date and today)

IF(Date(Today(),'YYYY-MM-DD') <= [Basic start date],0,
IF([Basic start date] <= Date(Today(),'YYYY-MM-DD') AND Date(Today(),'YYYY-MM-DD') <= [Basic finish date],Date(Today(),'YYYY-MM-DD') - [Basic start date],
[Basic finish date] - [Basic start date]))

Gantt_Project_3 (blue bar between Today and end date)

[Basic finish date] - Today()

CS_IW73:

LOAD

[sap.Auftrag.Quelle.IW73] AS Auftrag_Quelle_IW73_PM_Chargeable e 

,[sap.Auftrag.IW73] AS [CS order chargeable]

,[sap.Erfassungsdatum.IW73] AS Erfassungsdatum_IW73_Chargeable 

,[sap.Gesamtkosten_Ist.IW73] AS IstKosten_IW73_Chargeable

,if([sap.Erfassungsdatum.IW73] < Date#('01.09.2023', 'DD.MM.YYYY')

     OR [sap.Gesamtkosten_Geschätzt.IW73] = 0,

           [sap.Gesamtkosten_Plan.IW73],[sap.Gesamtkosten_Geschätzt.IW73]) AS

                 SchätzKosten_IW73_Chargeable

,[sap.Gesamtkosten_Plan.IW73] AS PlanKosten_IW73_Chargeable

,[sap.Gesamterlöse_Ist.IW73] AS IstErlös_IW73_Chargeable 

,[sap.Währung.IW73] AS Währung_IW73_Chargeable

,[sap.Eckstarttermin.IW73] AS [Basic start date]

,[sap.Eckendtermin.IW73] AS [Basic finish date]

,[sap.Änderungsdatum_Auftragsstamm.IW73] AS [Last change]

Resident sap.IW73;

Association between both tables 

IW49N_Vorgänge:   

LOAD 

[sap.Auftrag.Quelle.IW49N] AS Auftrag_Quelle_IW73_PM_Chargeable

,[sap.IstStd.IW49N] AS IstStd_IW49N_Vorgang

,[sap.PlanStd.IW49N] AS PlanStd_IW49N_Vorgang  

,[sap.KurztextVorgang.IW49N] AS Object

,[sap.Vorgang.IW49N] AS [Object no.]

,if(IsNull([sap.Vorgang.EinschrStart.IW49N]),null(),[sap.KurztextVorgang.IW49N]) AS Milesstone

,[sap.Vorgang.EinschrStart.IW49N] AS [Milesstone date]

Resident sap.IW49N;