https://community.qlik.com/t5/App-Development/Multiple-Line-Chart-to-detect-an-outlier-in-the-data/m-p/1727903#M55489 <P>Hello, everyone,<BR />I would like to display two graphs with the following data structure.</P><TABLE border="0" width="480" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">Order</TD><TD width="80">Material</TD><TD width="80">Productgroup</TD><TD width="80">Op</TD><TD width="80">LeadTime</TD><TD width="80">MonthYear</TD></TR><TR><TD height="20">1</TD><TD>33</TD><TD>component</TD><TD>10</TD><TD>2</TD><TD>June 2020</TD></TR><TR><TD height="20">1</TD><TD>33</TD><TD>component</TD><TD>20</TD><TD>3</TD><TD>June 2020</TD></TR><TR><TD height="20">1</TD><TD>33</TD><TD>component</TD><TD>30</TD><TD>5</TD><TD>June 2020</TD></TR><TR><TD height="20">2</TD><TD>25</TD><TD>component</TD><TD>10</TD><TD>1</TD><TD>June 2020</TD></TR><TR><TD height="20">2</TD><TD>25</TD><TD>component</TD><TD>20</TD><TD>3</TD><TD>June 2020</TD></TR><TR><TD height="20">2</TD><TD>25</TD><TD>component</TD><TD>30</TD><TD>2</TD><TD>June 2020</TD></TR><TR><TD height="20">3</TD><TD>33</TD><TD>component</TD><TD>10</TD><TD>8</TD><TD>July 2020</TD></TR><TR><TD height="20">3</TD><TD>33</TD><TD>component</TD><TD>20</TD><TD>9</TD><TD>July 2020</TD></TR><TR><TD height="20">3</TD><TD>33</TD><TD>component</TD><TD>30</TD><TD>7</TD><TD>July 2020</TD></TR><TR><TD height="20">4</TD><TD>25</TD><TD>component</TD><TD>10</TD><TD>2</TD><TD>July 2020</TD></TR><TR><TD height="20">4</TD><TD>25</TD><TD>component</TD><TD>20</TD><TD>8</TD><TD>July 2020</TD></TR><TR><TD height="20">4</TD><TD>25</TD><TD>component</TD><TD>30</TD><TD>6</TD><TD>July 2020</TD></TR></TBODY></TABLE><P><BR />The first would be the average of the product group over time.<BR />The second would be the average of the individual material numbers over time.<BR />I will use the following formula for the average of the product groups.</P><P>&nbsp;</P><LI-CODE lang="javascript">sum(aggr(avg(LeadTime), Op, Productgroup, MonthYear))</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="teszt.PNG" style="width: 970px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37438i2C0DEEE56655E044/image-size/large?v=v2&amp;px=999" role="button" title="teszt.PNG" alt="teszt.PNG" /></span></P><P>how can I use this formula to display material numbers? I want to see many individual lines. The following approach was not working.</P><P>&nbsp;</P><LI-CODE lang="javascript">sum(aggr(avg(LeadTime), Op, Material, MonthYear))</LI-CODE><P>&nbsp;</P><P>I want to get something like this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ui_gen_LineChart" style="width: 710px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37437iC1D90E8E9A252F57/image-size/large?v=v2&amp;px=999" role="button" title="ui_gen_LineChart" alt="ui_gen_LineChart" /></span></P><P>Thanks in advance!</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Sat, 16 Nov 2024 18:21:58 GMT rohi__ 2024-11-16T18:21:58Z https://community.qlik.com/t5/App-Development/Multiple-Line-Chart-to-detect-an-outlier-in-the-data/m-p/1727903#M55489 <P>Hello, everyone,<BR />I would like to display two graphs with the following data structure.</P><TABLE border="0" width="480" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">Order</TD><TD width="80">Material</TD><TD width="80">Productgroup</TD><TD width="80">Op</TD><TD width="80">LeadTime</TD><TD width="80">MonthYear</TD></TR><TR><TD height="20">1</TD><TD>33</TD><TD>component</TD><TD>10</TD><TD>2</TD><TD>June 2020</TD></TR><TR><TD height="20">1</TD><TD>33</TD><TD>component</TD><TD>20</TD><TD>3</TD><TD>June 2020</TD></TR><TR><TD height="20">1</TD><TD>33</TD><TD>component</TD><TD>30</TD><TD>5</TD><TD>June 2020</TD></TR><TR><TD height="20">2</TD><TD>25</TD><TD>component</TD><TD>10</TD><TD>1</TD><TD>June 2020</TD></TR><TR><TD height="20">2</TD><TD>25</TD><TD>component</TD><TD>20</TD><TD>3</TD><TD>June 2020</TD></TR><TR><TD height="20">2</TD><TD>25</TD><TD>component</TD><TD>30</TD><TD>2</TD><TD>June 2020</TD></TR><TR><TD height="20">3</TD><TD>33</TD><TD>component</TD><TD>10</TD><TD>8</TD><TD>July 2020</TD></TR><TR><TD height="20">3</TD><TD>33</TD><TD>component</TD><TD>20</TD><TD>9</TD><TD>July 2020</TD></TR><TR><TD height="20">3</TD><TD>33</TD><TD>component</TD><TD>30</TD><TD>7</TD><TD>July 2020</TD></TR><TR><TD height="20">4</TD><TD>25</TD><TD>component</TD><TD>10</TD><TD>2</TD><TD>July 2020</TD></TR><TR><TD height="20">4</TD><TD>25</TD><TD>component</TD><TD>20</TD><TD>8</TD><TD>July 2020</TD></TR><TR><TD height="20">4</TD><TD>25</TD><TD>component</TD><TD>30</TD><TD>6</TD><TD>July 2020</TD></TR></TBODY></TABLE><P><BR />The first would be the average of the product group over time.<BR />The second would be the average of the individual material numbers over time.<BR />I will use the following formula for the average of the product groups.</P><P>&nbsp;</P><LI-CODE lang="javascript">sum(aggr(avg(LeadTime), Op, Productgroup, MonthYear))</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="teszt.PNG" style="width: 970px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37438i2C0DEEE56655E044/image-size/large?v=v2&amp;px=999" role="button" title="teszt.PNG" alt="teszt.PNG" /></span></P><P>how can I use this formula to display material numbers? I want to see many individual lines. The following approach was not working.</P><P>&nbsp;</P><LI-CODE lang="javascript">sum(aggr(avg(LeadTime), Op, Material, MonthYear))</LI-CODE><P>&nbsp;</P><P>I want to get something like this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ui_gen_LineChart" style="width: 710px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37437iC1D90E8E9A252F57/image-size/large?v=v2&amp;px=999" role="button" title="ui_gen_LineChart" alt="ui_gen_LineChart" /></span></P><P>Thanks in advance!</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Sat, 16 Nov 2024 18:21:58 GMT https://community.qlik.com/t5/App-Development/Multiple-Line-Chart-to-detect-an-outlier-in-the-data/m-p/1727903#M55489 rohi__ 2024-11-16T18:21:58Z