View and analyze stock indicators over adjacent monthly periods.

Module name

Trigram: SKE




The Stock Evolution sheet allows you to analyze the last 36 months:

  • The evolution of stocks volumes on the market and retail by segment, laboratory, brand and product

  • The number of stockist pharmacies, stockist digital distribution and stockist value distribution

  • The performance of stockist pharmacies, thanks to DNV / DNS and DVV / DVS ratios

This module is for you if:

  • Stock is a key indicator in your trading performance

  • Your activity is seasonal and stock has an impact on sales

  • You or your competitors are leading an active drugstore storage strategy

Data sources

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



Sales & Marketing Advanced

Objects found in the sheet

  • Functional cartridge

  • Time buttons

  • temporal selector

  • Indicator buttons

  • Company

  • Object 'Stock Distribution'

  • Object 'Stock Evolution (volume)'

  • Object 'Stock Comparison (volume)'

  • 'Transformation Rate Stock' object

Indicators & measures

  • Stock Volume

  • Number of stockist pharmacies

  • Stockist Value Distribution

  • Stockist Volume Distribution

  • DNV / DNS ratio

  • DVV / DVS ratio


  • Qualifying Fields Product Fields (CQCP) in MyQuery


Current version:

Stock v2009301654 Evolution

  • Enhancement of the bar-graph according to the grid and replacement of the drop-down selector.

Old versions:

Stock v2009141457 Evolution

  • Addition of the "Data Input" Warning within the traceability cartridge

Stock Evolution v2007031546

  • Changed the size of the Grid and the placement of objects closer to the original and added the DOE (Internal Technical Improvement) cartridge

Stock Evolution v2006160000

  • Addition to the Line Chart at the top left of the N Monthly Rebased NDStock indicators and the Rebased ND Sales / Rebased ND Stock ratio indicator.

Stock v2004271727 Evolution

  • Module recipe version v2004271727 standard , no change compared to version v2004070930 of this module.

  • The WD Sales / WD Stock indicator is not currently available in this module version.

Stock Evolution v2004070930

  • Removal of the "PHARMA ONLY" mention just below the market to group the traceability dates together.

  • Added labels to the "Transformation Rate Stock" scatter plot as well as to the "Stock Comparison (Volume)"

  • Variability of the subscription within the cartridge.


target> Stock9"_200ank vwx7

  • Changed the time dimension of all charts from Period_MonthName to Period_MonthName_formatted

Stock Evolution v2001091610

  • Complete variability of all graphic labels (dimensions, measures)

Evolution> p 0Y000001Iu7o #

  • Modification of the previous automation of the market qualifying hierarchical field selector for more speed when updating the App. (dynamic value) (Internal Technical Improvement).

Stock v1909111730 Evolution

  • Modification of the display modalities selector with addition of hierarchical fields qualifying the market, automatically.

Stock Evolution v1908091455

  • Fix for "Success" link

Stock V1906261223 Evolution

  • The indicators are pre-calculated in the App modeling stage. This sheet can only be displayed in version vF51 of the flow. (Internal Technical Improvement)

target=Evolution"Https4lsSwank52" target> Evolution"Https //www.snhklUWjcmAC73Js4lsSwank52" target Evolution

  • Internal Technical Improvement

Stock Evolution v1904251608

  • Implementation of the link to "Success"

Did this answer your question?