Module name




The Traffic Forecast sheet is the sheet used to make forecasts on dispensary traffic.
This sheet is based on the Python OpenSource Prophet library made by Facebook. The PyTools 5.1 connector has been integrated into QLIK to achieve this decomposition. The decomposition method used in this library is based on the ARIMA calculation method.
This module is for you if:

  • You want to estimate the impact of an event on pharmacy traffic

  • You want to carry out advanced analyzes on a market

Data source

Geographic territories

  • Metropolitan France data


  • No limitation on the size of the markets

  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products




Objects present in the sheet

  • Functional cartridge

  • Dispensation / Volume / Volume per dispensation / GTIN per dispensation selector button

  • Mode selector button from Additive / Multiplicative decomposition

  • Learning period selector

  • Time selector

  • Confidence level slider

  • Prescription type selector

  • Forecast curve

  • KPIs for cumulative supernumerary for volume and dispensations

  • Average supernumerary KPIs for volume per dispensation and GTINs per dispensation

  • Supernumerary Analysis Bar Graph


  • Quarterly and yearly forecasts do not have enough training data to be reliable enough

  • It is imperative to choose a learning period to obtain a visualization


= = traffic v2003241304:

Addition of different temporalities, granularity to the product

traffic v2003191732:

Added KPIs, changed sorting of bar chart

target> traffic v2003182206:

First version

Did this answer your question?