Let's get started

Just provide us with your contact information and we will give you access to our demo site where you can see for yourself how well our extensions integrates with Qlik Sense.
We promise a seamless experience.

Trusted by Qlik customers and partners around the world

Novo Nordisk logo
Sandvine logo
Ferring Pharmaceuticals logo
Applause logo
Celdomy logo
Apotex logo

E-mail addresses are never shared with third-parties.

Thank you!

We will get back to you very soon.
Oops! Something went wrong while submitting the form.

Global pharmaceutical company use Qlik Sense and Komment for data reconciliation

Global pharmaceutical company use Qlik Sense and Komment for data reconciliation

Different use cases for writeback capabilities

A global pharmaceutical company is using Qlik Sense and Komment, the native writeback extension, to solve several complex use cases within their clinical trial and pharmacovigilance activities.

The pharmaceutical industry has historically been supported by SAS and Excel when transforming, reviewing and analyzing data. However, in recent years we have seen a transformation where the industry is moving to more flexible tools such as Qlik Sense. In this short article we highlight just a few of the many possible use cases for Qlik Sense in combination with a writeback solution such as Komment.

The company uses Komment to add and change data in their apps to solve critical tasks such as:

  • Data reconciliation
  • Case report submissions and compliance
  • Signal detection

Data reconciliation

Basically all companies spend a lot of time reconciling data between two systems and the current pharmaceutical company was no exception. They needed a reliable way to help lower the time spent on looking for duplicate records, and help match records unrecognized by the system as duplicates. With the use of Komment and its writeback functionality they have been able to perform their data reconciliation much faster and at a higher quality.

This was to a great deal due to the fact that the end users no longer needed to switch between multiple systems when performing the data reconciliation. Before, all of the steps where a manual process conducted by a trial manager who'd previously spend valuable time finding matching and missing protocol deviations (PDs) between the two systems.

Case report submissions and compliance

The second solution was built to keep track of case report submissions and compliance. As a case was received there was a regulatory reporting requirement dependent on the nature of the case and the company wanted to get an overview of the report submission timeliness with regards to the regulations. The solution was also designed to keep track of incoming and outgoing reports for reconciliation with external sites. For this app the customer requested a way of being able to add comments and categorizations to a case or report. For this we used naturally used Komment. That made it possible to append all the necessary meta data as well as create a viable audit trail for regulatory purposes.

Signal Detection

The final use case we will mention here, was to create an Qlik Sense app that could continuously monitor and track any potential increases in reporting for specific adverse events. This procedure was previously handled using Excel and automated reports directly from the source system. There was however very limited information accessible in these automated reports and so the company wanted us to display comprehensive case details and history aside from the statistics.

We created a highly flexible,dynamic set of calculations that allowed for the end users to specify date range, product and events and compare the frequencies with the ones from FDA's external database FAERS. This, bundled with Komment on three different data points, served as a quick, stable, and dynamic way for the end user to independently explore, annotate and mine the data. The end users could now perform their reporting on any given interval, without having to prompt or involve other departments. They could annotate, document and display their findings in accordance with regulations and perform continuous signal detection when needed.

If you have any questions please reach out using of the contact forms or send us a mail on info@extendbi.com.

Other case studies

Finally a CRM system you want to use - powered by Qlik & Komment™

Get up to speed on how you can use Qlik as your CRM system when you have Komment™ installed

Do your sales budgeting and forecasting directly in Qlik Sense

Learn how easy it is to do your budgeting and forecasting in Qlik Sense using Komment™

Learn how Komment can be applied in the financial industry

Glofitech benefits from using the writeback functionality in Komment within several departments.

Want to know more?

Let us know and we'll get back to you as soon as possible.

Daniel Andersen

Daniel Andersen

Director, Products & Extensions

Thank you!

Your submission has been received!
Oops! Something went wrong while submitting the form.

Meet some of our partners

Victa logo
At Once logo
Catalyst logo
element61 logo
Pengon logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo
Mathias Consulting Training Schreiber logo