topic Variation données avec dates / Data variation with dates in QlikView https://community.qlik.com/t5/QlikView/Variation-donn%C3%A9es-avec-dates-Data-variation-with-dates/m-p/5895#M607366 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>Je souhaiterais savoir comment ajouter à un tableau croisé dynamique dans QlikView une <STRONG>colonne "variation"</STRONG></P><P>Concrètement j'aimerais calculer l'évolution de valeurs entre 2 dates.</P><P>Exemple : Pour le mot clé <STRONG>"Canapé"</STRONG>, j'ai une valeur de <STRONG>"1" au 18/01</STRONG> et une valeur de <STRONG>"8" au 23/01</STRONG>. La colonne variation afficherait donc <SPAN style="color: #ff0000;">"-7"</SPAN></P><P>Mon but est de pouvoir ajouter une colonne qui donnera la variation des valeurs entre les deux dates.</P><P></P><P>Quelqu'un pour m'aider ? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Merci !</P><P></P><P style="text-align: center;"><SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN>== Traduction ==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P></P><P>Hello,</P><P></P><P>I would like to know how to add a variation column to a PivotTable in QlikView.</P><P>Concretely I would like to calculate the evolution of values ​​between 2 dates.</P><P>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"</P><P></P><P>My goal is to be able to add a column which will give the variation of the values ​​between the two dates.</P><P></P><P>Someone to help me?</P><P></P><P>Thank you !</P></BODY></HTML> Tue, 23 Jan 2018 18:02:01 GMT Anonymous 2018-01-23T18:02:01Z Variation données avec dates / Data variation with dates https://community.qlik.com/t5/QlikView/Variation-donn%C3%A9es-avec-dates-Data-variation-with-dates/m-p/5895#M607366 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>Je souhaiterais savoir comment ajouter à un tableau croisé dynamique dans QlikView une <STRONG>colonne "variation"</STRONG></P><P>Concrètement j'aimerais calculer l'évolution de valeurs entre 2 dates.</P><P>Exemple : Pour le mot clé <STRONG>"Canapé"</STRONG>, j'ai une valeur de <STRONG>"1" au 18/01</STRONG> et une valeur de <STRONG>"8" au 23/01</STRONG>. La colonne variation afficherait donc <SPAN style="color: #ff0000;">"-7"</SPAN></P><P>Mon but est de pouvoir ajouter une colonne qui donnera la variation des valeurs entre les deux dates.</P><P></P><P>Quelqu'un pour m'aider ? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Merci !</P><P></P><P style="text-align: center;"><SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN>== Traduction ==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==<SPAN style="text-align: center;">==</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P></P><P>Hello,</P><P></P><P>I would like to know how to add a variation column to a PivotTable in QlikView.</P><P>Concretely I would like to calculate the evolution of values ​​between 2 dates.</P><P>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"</P><P></P><P>My goal is to be able to add a column which will give the variation of the values ​​between the two dates.</P><P></P><P>Someone to help me?</P><P></P><P>Thank you !</P></BODY></HTML> Tue, 23 Jan 2018 18:02:01 GMT https://community.qlik.com/t5/QlikView/Variation-donn%C3%A9es-avec-dates-Data-variation-with-dates/m-p/5895#M607366 Anonymous 2018-01-23T18:02:01Z