https://community.qlik.com/t5/QlikView/Price-variations-by-aggregation/m-p/1517922#M748975 <P>any help, guys?</P> Fri, 07 Dec 2018 11:34:50 GMT andreip21 2018-12-07T11:34:50Z https://community.qlik.com/t5/QlikView/Price-variations-by-aggregation/m-p/1517660#M748974 <P>Hello all,</P><P>I have the following data: 6 products from 2 brands and price during 6 days period:</P><TABLE><TBODY><TR><TD>Brand</TD><TD>Product ID</TD><TD>1-Dec</TD><TD>2-Dec</TD><TD>3-Dec</TD><TD>4-Dec</TD><TD>5-Dec</TD><TD>6-Dec</TD></TR><TR><TD>A</TD><TD>1</TD><TD>20</TD><TD>20</TD><TD>-</TD><TD>20</TD><TD>30</TD><TD>30</TD></TR><TR><TD>A</TD><TD>2</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>45</TD><TD>45</TD></TR><TR><TD>A</TD><TD>3</TD><TD>75</TD><TD>60</TD><TD>60</TD><TD>80</TD><TD>80</TD><TD>80</TD></TR><TR><TD>A</TD><TD>4</TD><TD>10</TD><TD>10</TD><TD>10</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B</TD><TD>5</TD><TD>100</TD><TD>100</TD><TD>100</TD><TD>100</TD><TD>90</TD><TD>90</TD></TR><TR><TD>B</TD><TD>6</TD><TD>35</TD><TD>-</TD><TD>40</TD><TD>30</TD><TD>30</TD><TD>30</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i will have differences day by day (2-Dec vs 1-Dec, 3-Dec vs 2-Dec):</P><P>when the product has no price in 2 consecutive days, the differences will be 0 (e.g. product ID 6 on 2-Dec vs 1-Dec)</P><TABLE><TBODY><TR><TD>Brand</TD><TD>Product ID</TD><TD>1-Dec</TD><TD>2-Dec</TD><TD>3-Dec</TD><TD>4-Dec</TD><TD>5-Dec</TD><TD>6-Dec</TD></TR><TR><TD>A</TD><TD>1</TD><TD>&nbsp;</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>10</TD><TD>0</TD></TR><TR><TD>A</TD><TD>2</TD><TD>&nbsp;</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>A</TD><TD>3</TD><TD>&nbsp;</TD><TD>-15</TD><TD>0</TD><TD>20</TD><TD>0</TD><TD>0</TD></TR><TR><TD>A</TD><TD>4</TD><TD>&nbsp;</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>B</TD><TD>5</TD><TD>&nbsp;</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>-10</TD><TD>0</TD></TR><TR><TD>B</TD><TD>6</TD><TD>&nbsp;</TD><TD><FONT color="#FF6600">0</FONT></TD><TD>0</TD><TD>-10</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>and then i want to calculate for the 2 brands the price variations between days:</P><TABLE><TBODY><TR><TD>Brand</TD><TD>&nbsp;</TD><TD>1-Dec</TD><TD>2-Dec</TD><TD>3-Dec</TD><TD>4-Dec</TD><TD>5-Dec</TD><TD>6-Dec</TD></TR><TR><TD>A</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>-14%</TD><TD>0%</TD><TD>33%</TD><TD>10%</TD><TD>0%</TD></TR><TR><TD>B</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>0%</TD><TD>0%</TD><TD>-7%</TD><TD>-8%</TD><TD>0%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>the formula for the last table will be:</P><P>By Brand: Sum of differences 2-Dec (from second table)/ Sum of prices 1-Dec (from first table)</P><P>but only for products that have positive values on 2 consecutive days (1-Dec and 2-Dec)</P><P>&nbsp;</P><P>I attached the Excel file with an easy understand of what i want.</P><P>&nbsp;</P><P>How to do this in Qlik?</P><P>&nbsp;</P><P>Thank you,</P><P>Andrei</P> Sat, 16 Nov 2024 21:45:54 GMT https://community.qlik.com/t5/QlikView/Price-variations-by-aggregation/m-p/1517660#M748974 andreip21 2024-11-16T21:45:54Z https://community.qlik.com/t5/QlikView/Price-variations-by-aggregation/m-p/1517922#M748975 <P>any help, guys?</P> Fri, 07 Dec 2018 11:34:50 GMT https://community.qlik.com/t5/QlikView/Price-variations-by-aggregation/m-p/1517922#M748975 andreip21 2018-12-07T11:34:50Z