Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pierrecdiscount
New Contributor

Variation données avec dates / Data variation with dates

Bonjour,

Je souhaiterais savoir comment ajouter à un tableau croisé dynamique dans QlikView une colonne "variation"

Concrètement j'aimerais calculer l'évolution de valeurs entre 2 dates.

Exemple : Pour le mot clé "Canapé", j'ai une valeur de "1" au 18/01 et une valeur de "8" au 23/01. La colonne variation afficherait donc "-7"

Mon but est de pouvoir ajouter une colonne qui donnera la variation des valeurs entre les deux dates.

Quelqu'un pour m'aider ?

Merci !

================ Traduction ==================

Hello,

I would like to know how to add a variation column to a PivotTable in QlikView.

Concretely I would like to calculate the evolution of values ​​between 2 dates.

Example: For the keyword "Sofa", I have a value of "1" at 18/01 and a value of "8" at 23/01. The variation column would show "-7"

My goal is to be able to add a column which will give the variation of the values ​​between the two dates.

Someone to help me?

Thank you !

Community Browser