Name of the module

Trigram: MPA

Version: v2203251500

Tutorial

Value proposition

View all your indicators in a customised table:

Arrange the rows of your table using your segments, qualifiers and measures
View all your indicators
Export your table to Excel
Create a bookmark to view this table routinely

This module is for you if :

You want to create a table that allows you to view several indicators and timeframes in a combined way

Data sources

Data from pharmacies
GSA parapharmacies data (sales volumes and value only)

Geographical territories

Data for Metropolitan France
Corsica
DROM-COM

Market

Limitations may apply depending on the size of the market
Applicable to human, veterinary and non-medicinal products

Status

Subscription

Sales & Marketing Essential

Objects in the module

Functional cartridge
Reference period
Object 'Visualisations'.
On and Off Prescription" selector

Indicators and measures (full list at the bottom of this article)

Compatible Options

Product qualifying fields
Customer type

Limitations

No stock indicator
Calendar time periods only
Dispensing indicators and MSM are only available in pharmacies
The leading indicators are only available for the territory of Metropolitan France excluding Corsica.
Only the Distributions (DNV, DVV) recalculated at the Global level during the analysis period are available in this module.
The moduleOn Demand Table is complementary to this one, it will allow you to visualise the Distributions not recalculated at the Global level during the analysis period.
Only theAS calculated over the full analysis period are available in this module.
The moduleOn Demand Table is complementary to this one, it will allow you to visualize theAMS as well as theAMS A.

Tip (applicable from version 2007011819) :

Select a measure, click and hold, then scroll down the selection. This will allow you to build a complete table containing all available measures.

Exhaustive list of Indicators and measures to date in the module:

Table with turnover and volume :

To: Last Month

To: Last Month evol

To: Last Month-1

To: Last Quarter

To: Last Quarter evol

To: Last Quarter-1

To: Last Year

To: Last Year evol

To: Last Year-1

To: MAT

To: MAT evol

To: MAT-1

To: MQT

To: MQT evol

To: MQT-1

To: MTD

To: MTD evol

To: MTD-1

To: QTD

To: QTD evol

To: QTD-1

To: YTD

To: YTD evol

To: YTD-1

To-MS: Last Month

To-MS: Last Month delta

To-MS: Last Month-1

To-MS : Last Quarter

To-MS: Last Quarter delta

To-MS: Last Quarter-1

To-MS: Last Year

To-MS: Last Year delta

To-MS: Last Year-1

To-MS: MAT

To-MS: MAT delta

To-MS : MAT-1

To-MS : MQT

To-MS: MQT delta

To-MS: MQT-1

To-MS : MTD

To-MS: MTD delta

To-MS: MTD-1

To-MS: QTD

To-MS: QTD delta

To-MS: QTD-1

To-MS: YTD

To-MS: YTD delta

To-MS: YTD-1

Flight : Last Month

Flight : Last Month evol

Flight : Last Month-1

Flight : Last Quarter

Flight : Last Quarter evol

Flight : Last Quarter-1

Flight : Last Year

Flight: Last Year evol

Flight : Last Year-1

Flight : MAT

Flight: MAT evol

Flight : MAT-1

Flight : MQT

Flight: MQT evol

Flight : MQT-1

Flight: MTD

Flight: MTD evol

Flight : MTD-1

Flight: QTD

Flight: QTD evol

Flight: QTD-1

Flight : YTD

Flight : YTD evol

Flight : YTD-1

Vol-MS: Last Month

Vol-MS: Last Month delta

Vol-MS: Last Month-1

Vol-MS : Last Quarter

Vol-MS: Last Quarter delta

Flight-MS: Last Quarter-1

Vol-MS: Last Year

Vol-MS: Last Year delta

Flight-MS: Last Year-1

Flight-MS: MAT

Flight-MS: MAT delta

Flight-MS: MAT-1

Flight-MS: MQT

Flight-MS: MQT delta

Flight-MS: MQT-1

Vol-MS: BAT

Flight-MS: MTD delta

Flight-MS: MTD-1

Flight-MS: QTD

Flight-MS: QTD delta

Vol-MS: QTD-1

Flight-MS: YTD

Flight-MS: YTD delta

Flight-MS: YTD-1

Table with advanced indicators :

AS : Last Month

AS: Last Month evol

AS: Last Month-1

AS: Last Quarter

AS: Last Quarter evol

AS: Last Quarter-1

AS: Last Year

AS: Last Year evol

AS: Last Year-1

AS: MAT

AS: MAT evol

AS: MAT-1

AS: MQT

AS: MQT evol

AS: MQT-1

AS: BAT

AS: MTD evol

AS: MTD-1

AS: QTD

AS: QTD evol

AS: QTD-1

AS: YTD

AS: YTD evol

AS: YTD-1

Global ND : Last Month

Global ND: Last Month delta

Global ND: Last Month-1

Global ND: Last Quarter

Global ND: Last Quarter delta

Global ND: Last Quarter-1

Global ND: Last Year

Global ND: Last Year delta

Global ND: Last Year-1

Global ND: MAT

Global ND: MAT delta

Global ND: MAT-1

Global ND: MQT

Global ND: MQT delta

Global ND: MQT-1

Global ND: BAT

Global ND: MTD delta

Global ND: MTD-1

Global ND: QTD

Global ND: QTD delta

Global ND: QTD-1

Global ND: YTD

Global ND: YTD delta

Global ND: YTD-1

Global WD : Last Month

Global WD: Last Month delta

Global WD: Last Month-1

Global WD: Last Quarter

Global WD: Last Quarter delta

Global WD: Last Quarter-1

Global WD: Last Year

Global WD: Last Year delta

Global WD: Last Year-1

Global WD : MAT

Global WD: MAT delta

Global WD : MAT-1

Global WD: MQT

Global WD: MQT delta

Global WD: MQT-1

Global WD: MTD

Global WD: MTD delta

Global WD: MTD-1

Global WD: QTD

Global WD: QTD delta

Global WD: QTD-1

Global WD: YTD

Global WD: YTD delta

Global WD : YTD-1

To-Pha: Last Month

To-Pha: Last Month evol

To-Pha: Last Month-1

To-Pha : Last Quarter

To-Pha: Last Quarter evol

To-Pha : Last Quarter-1

To-Pha: Last Year

To-Pha: Last Year evol

To-Pha : Last Year-1

To-Pha: MAT

To-Pha: MAT evol

To-Pha : MAT-1

To-Pha: MQT

To-Pha: MQT evol

To-Pha: MQT-1

To-Pha : MTD

To-Pha : MTD evol

To-Pha: MTD-1

To-Pha: QTD

To-Pha: QTD evol

To-Pha: QTD-1

To-Pha: YTD

To-Pha: YTD evol

To-Pha: YTD-1

To-Pha-MS : Last Month

To-Pha-MS: Last Month delta

To-Pha-MS: Last Month-1

To-Pha-MS : Last Quarter

To-Pha-MS: Last Quarter delta

To-Pha-MS : Last Quarter-1

To-Pha-MS: Last Year

To-Pha-MS: Last Year delta

To-Pha-MS : Last Year-1

To-Pha-MS: MAT

To-Pha-MS: MAT delta

To-Pha-MS : MAT-1

To-Pha-MS: MQT

To-Pha-MS: MQT delta

To-Pha-MS: MQT-1

To-Pha-MS : BAT

To-Pha-MS: Delta BAT

To-Pha-MS: MTD-1

To-Pha-MS: QTD

To-Pha-MS: QTD delta

To-Pha-MS: QTD-1

To-Pha-MS: YTD

To-Pha-MS: YTD delta

To-Pha-MS: YTD-1

Vol-Pha : Last Month

Vol-Pha : Last Month evol

Vol-Pha : Last Month-1

Vol-Pha : Last Quarter

Vol-Pha : Last Quarter evol

Vol-Pha : Last Quarter-1

Vol-Pha : Last Year

Vol-Pha : Last Year evol

Vol-Pha : Last Year-1

Vol-Pha : MAT

Vol-Pha: MAT evol

Vol-Pha : MAT-1

Vol-Pha: MQT

Vol-Pha: MQT evol

Vol-Pha: MQT-1

Vol-Pha : MTD

Vol-Pha : MTD evol

Vol-Pha: MTD-1

Vol-Pha: QTD

Vol-Pha: QTD evol

Vol-Pha: QTD-1

Vol-Pha: YTD

Vol-Pha: YTD evol

Vol-Pha: YTD-1

Vol-Pha-MS : Last Month

Vol-Pha-MS : Last Month delta

Vol-Pha-MS : Last Month-1

Vol-Pha-MS : Last Quarter

Vol-Pha-MS : Last Quarter delta

Vol-Pha-MS : Last Quarter-1

Vol-Pha-MS : Last Year

Vol-Pha-MS : Last Year delta

Vol-Pha-MS : Last Year-1

Vol-Pha-MS: MAT

Vol-Pha-MS: MAT delta

Vol-Pha-MS : MAT-1

Vol-Pha-MS: MQT

Vol-Pha-MS: MQT delta

Vol-Pha-MS: MQT-1

Vol-Pha-MS : BAT

Vol-Pha-MS : MTD delta

Vol-Pha-MS: MTD-1

Vol-Pha-MS: QTD

Vol-Pha-MS: QTD delta

Vol-Pha-MS: QTD-1

Vol-Pha-MS: YTD

Vol-Pha-MS: YTD delta

Vol-Pha-MS: YTD-1

WASP : Last Month

WASP: Last Month evol

WASP: Last Month-1

WASP: Last Quarter

WASP: Last Quarter evol

WASP: Last Quarter-1

WASP: Last Year

WASP: Last Year evolves

WASP: Last Year-1

WASP: MAT

WASP: MAT evol

WASP: MAT-1

WASP: MQT

WASP: MQT evol

WASP: MQT-1

WASP: MTD

WASP: MTD evol

WASP: MTD-1

WASP: QTD

WASP: QTD evol

WASP: QTD-1

WASP: YTD

WASP: YTD evol

WASP: YTD-1

Fields present in the All Products / MP4U version:

AFIPA_Category

AFIPA_Segments

AFIPA_SELFCARE

AFIPA_Sub-Segments

ANS ATCVet Level1

ANS ATCVet Level2

ANS ATCVet Level3

ANS ATCVet Level4

ANS ATCVet Level5

ANS_Code ATCVet

ANS_Condition Delivery

ANS_Species Destination

ANS_Nature

Brand

Company

EphMRA Code Level 1

EphMRA Code Level 2

EphMRA Code Level 3

EphMRA Code Level 4

Family

Freely Available

GTIN

IRI_Brand

IRI_Category

IRI_Company

IRI_Department

IRI_Ray

IRI_Sub-Ray

IRI_Sub-Type

IRI_Type

Line

Network

OHC Classification Level 1

OHC Classification Level 2

OHC Classification Level 3

OHC Classification Level 4

OHC Classification Level 5

OHC_DateInscriptionDTM

OHC_DateInscriptionSRC

OHC_Tech_BDDSource

OHC_Tech_DateTimeOut

WHO Code Level 1

WHO Code Level 2

WHO Code Level 3

WHO Code Level 4

WHO Code Level 5

Prescription Type

Product lining

Products

Segments

TECHNICAL CODE 2

THE_ Administration Way

THE_Active Substance

THE_CIS Code

THE_Complement Form

THE_Container

THE_Container Name

THE_Container Number

THE_Content_Number

THE_Content_Unit

THE_Dosage Base Substance Unit

THE_Form

THE_Generic Type

THE_GSP Code

THE_List

THE_Market Authorization first approval

THE_Nature

THE_Packaging Unit Name

THE_Packaging Units Number

THE_Reimbursement

THE_Substance Dosage

THE_Substance Dosage Unit

THE_Substance Father

THE_Substance Label

THE_UCD

THE_UCD Code

THE_UCD Nature

THE_UCD Number

THE_Way

Versions

Current version

Multiple Period Analysis v2203251500

Increase to 20 CQCP (Qualifying Fields Market Fields) that can be displayed in the pivot table according to the choice made by the drop-down selector provided for this purpose in the Market Definition module.
Correction of the Success link.

Multiple Period Analysis v2111150000

The "Listbox Measure" has been revised.

Multiple Period Analysis v2109071034

Modification in replacement of the CONTENEUR object (tables) for a native Qlik container
Modification of the VizLib ADVANCED TEXT object question mark icon (Success link) to switch VizLib to native Button object (Internal Technical Improvement)

Multiple Period Analysis v2108311219

Added sorting by ascending number in addition to sorting by state and alphabetical order within the native Segments filter

Earlier versions

Multiple Period Analysis v2108301629

Merging versionsv2106101214,v2106281220 andv2107071455
Changing the sort order of the drop-down selector

Multiple Period Analysis v2107071455

Replaced the array selection drop-down selector from the Variable extension to the Bunddle Variable Input extension.

Multiple Period Analysis v2106281220

Implementation of line highlighting on the hover of the detail tables "Table with Turnover and Volume" and "Table with advanced indicators

Multiple Period Analysis v2106101214

Added field =[$(MPA_Dims_Def_param(59))] to lift field THE_Dosage Base Substance Unit (EXT_UniteDosageBaseSubstance)
Modification of the field display condition (=$(MPA_Dims_Cond_param(70)) ) for the correct retrieval of the field THE_Contenance_Unit ( EXT_UNIT_CONTENANCE )

Multiple Period Analysis v2105261418

Implementation of the warning message "Please select at least one dimension or one measure and a Reference Month

Multiple Period Analysis v2104011154

Removal of ODT (Internal Technical Improvement) filters

When switching from the On Demand Table module to another module, it is no longer necessary to clean up the selection to ensure that the module opened after On Demand Table is displayed.

Multiple Period Analysis v2104011053

Removal of ODT (Internal Technical Improvement) filters

When switching from the On Demand Table module to another module, it is no longer necessary to clean up the selection to ensure that the module opened after On Demand Table is displayed.

Multiple Period Analysis v2101271541

Expansion of the standard native filters by two tiles to improve the user experience with sorting by selection status.

Multiple Period Analysis v21012501250

Modification of native standard field filters in line with the new version of Market Definition.

Multiple Period Analysis v2101221530

Setting up sorting by status for Dimensions and Measures filters

Multiple Period Analysis v2012071640

Definition of Segment, Company, Brand, Product filters as Master Dimension to correct their headers when exporting selections to Excel (Internal Technical Notice: based on Market_Defined_[dimension_name])

Multiple Period Analysis v2011051418

Raising the drop-down selector for the tables to be displayed
Dimensions filter enlargement like the ODT module