Bar Chart with Dates Help - Qlik Community

Anonymous · ‎2017-11-09

Hello All,

I am trying to create a horizontal stacked bar chart to show dates. For example, I have a product field that has 4 different dates showing the product lifecycle (research, active, declining, terminate). I want the stacked bars to be connected to show a timeline. Excuse this poorly "drawn" example:

<---research---><----active---><---declining---><---terminate--->

where the x axis is the date and the y axis is the product.

How should my expressions look to create this timeline?

Thanks,

Jake

Anil_Babu_Samineni · ‎2017-11-13

Terminology is not clear to me. Because, you started with Dates and you are initiating PLC what does that?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-11-13

I have 4 dates in total. The first date is the research date (the date at which the product is in the research phase). The second date is the active date (the date that product is active). These two dates then make up the first bar in the bar chart (researchDate-activeDate). The next bar (stacked on top of the previous) would be (activeDate-decliningDate), then (decliningDate-eliminateDate), then (eliminateDate + 1 year)