topic Create trends from different dates in App Development

topic Create trends from different dates in App Development https://community.qlik.com/t5/App-Development/Create-trends-from-different-dates/m-p/1697596#M53381 <P>Hi,</P><P>I have the following sales data:</P><TABLE width="384"><TBODY><TR><TD width="79px" height="47px">Date</TD><TD width="102px" height="47px">Sales product A</TD><TD width="101px" height="47px">Sales product B</TD><TD width="101px" height="47px">Sales product C</TD></TR><TR><TD width="79px" height="25px">jan.20</TD><TD width="102px" height="25px"><STRONG>100</STRONG></TD><TD width="101px" height="25px"> </TD><TD width="101px" height="25px"> </TD></TR><TR><TD width="79px" height="25px">feb.20</TD><TD width="102px" height="25px">50</TD><TD width="101px" height="25px"><STRONG>90</STRONG></TD><TD width="101px" height="25px"> </TD></TR><TR><TD width="79px" height="25px">mar.20</TD><TD width="102px" height="25px">60</TD><TD width="101px" height="25px">60</TD><TD width="101px" height="25px"><STRONG>110</STRONG></TD></TR><TR><TD width="79px" height="25px">apr.20</TD><TD width="102px" height="25px">78</TD><TD width="101px" height="25px">60</TD><TD width="101px" height="25px">30</TD></TR><TR><TD width="79px" height="25px">mai.20</TD><TD width="102px" height="25px">60</TD><TD width="101px" height="25px">50</TD><TD width="101px" height="25px">30</TD></TR><TR><TD width="79px" height="25px">jun.20</TD><TD width="102px" height="25px"> </TD><TD width="101px" height="25px"> </TD><TD width="101px" height="25px">50</TD></TR></TBODY></TABLE><P> </P><P>I want to create a first, second, third ect. sales month.<BR />Rather than compare jan.20 with feb.20.</P><P>How can i creat a table like this:</P><TABLE width="182"><TBODY><TR><TD width="80">Month</TD><TD width="102">Total sales</TD></TR><TR><TD>1</TD><TD><STRONG>300</STRONG></TD></TR><TR><TD>2</TD><TD>140</TD></TR><TR><TD>3</TD><TD>150</TD></TR><TR><TD>4</TD><TD>178</TD></TR><TR><TD>5</TD><TD>60</TD></TR></TBODY></TABLE><P> </P><P>Thanks!</P> Wed, 29 Apr 2020 08:22:36 GMT Hauglaen 2020-04-29T08:22:36Z Create trends from different dates https://community.qlik.com/t5/App-Development/Create-trends-from-different-dates/m-p/1697596#M53381 <P>Hi,</P><P>I have the following sales data:</P><TABLE width="384"><TBODY><TR><TD width="79px" height="47px">Date</TD><TD width="102px" height="47px">Sales product A</TD><TD width="101px" height="47px">Sales product B</TD><TD width="101px" height="47px">Sales product C</TD></TR><TR><TD width="79px" height="25px">jan.20</TD><TD width="102px" height="25px"><STRONG>100</STRONG></TD><TD width="101px" height="25px"> </TD><TD width="101px" height="25px"> </TD></TR><TR><TD width="79px" height="25px">feb.20</TD><TD width="102px" height="25px">50</TD><TD width="101px" height="25px"><STRONG>90</STRONG></TD><TD width="101px" height="25px"> </TD></TR><TR><TD width="79px" height="25px">mar.20</TD><TD width="102px" height="25px">60</TD><TD width="101px" height="25px">60</TD><TD width="101px" height="25px"><STRONG>110</STRONG></TD></TR><TR><TD width="79px" height="25px">apr.20</TD><TD width="102px" height="25px">78</TD><TD width="101px" height="25px">60</TD><TD width="101px" height="25px">30</TD></TR><TR><TD width="79px" height="25px">mai.20</TD><TD width="102px" height="25px">60</TD><TD width="101px" height="25px">50</TD><TD width="101px" height="25px">30</TD></TR><TR><TD width="79px" height="25px">jun.20</TD><TD width="102px" height="25px"> </TD><TD width="101px" height="25px"> </TD><TD width="101px" height="25px">50</TD></TR></TBODY></TABLE><P> </P><P>I want to create a first, second, third ect. sales month.<BR />Rather than compare jan.20 with feb.20.</P><P>How can i creat a table like this:</P><TABLE width="182"><TBODY><TR><TD width="80">Month</TD><TD width="102">Total sales</TD></TR><TR><TD>1</TD><TD><STRONG>300</STRONG></TD></TR><TR><TD>2</TD><TD>140</TD></TR><TR><TD>3</TD><TD>150</TD></TR><TR><TD>4</TD><TD>178</TD></TR><TR><TD>5</TD><TD>60</TD></TR></TBODY></TABLE><P> </P><P>Thanks!</P> Wed, 29 Apr 2020 08:22:36 GMT https://community.qlik.com/t5/App-Development/Create-trends-from-different-dates/m-p/1697596#M53381 Hauglaen 2020-04-29T08:22:36Z