topic Question: Common Percentage in Line Graph for Multiple Items in QlikView https://community.qlik.com/t5/QlikView/Question-Common-Percentage-in-Line-Graph-for-Multiple-Items/m-p/713018#M538530 <HTML><HEAD></HEAD><BODY><P>I am graphing 4 different items on a date vs. percent complete line graph.&nbsp; Each item is based on 100%.&nbsp; When I sort using a list box the data works because it is only showing one item which can reach 100%.&nbsp; When I remove the filter and show all items in one line it is equal to 400%.&nbsp; Is there a way to make everything work on a 100% scale using one line with or without the filter?&nbsp; Thanks for your help!</P><P>Emily</P></BODY></HTML> Thu, 04 Sep 2014 21:29:18 GMT 2014-09-04T21:29:18Z Question: Common Percentage in Line Graph for Multiple Items https://community.qlik.com/t5/QlikView/Question-Common-Percentage-in-Line-Graph-for-Multiple-Items/m-p/713018#M538530 <HTML><HEAD></HEAD><BODY><P>I am graphing 4 different items on a date vs. percent complete line graph.&nbsp; Each item is based on 100%.&nbsp; When I sort using a list box the data works because it is only showing one item which can reach 100%.&nbsp; When I remove the filter and show all items in one line it is equal to 400%.&nbsp; Is there a way to make everything work on a 100% scale using one line with or without the filter?&nbsp; Thanks for your help!</P><P>Emily</P></BODY></HTML> Thu, 04 Sep 2014 21:29:18 GMT https://community.qlik.com/t5/QlikView/Question-Common-Percentage-in-Line-Graph-for-Multiple-Items/m-p/713018#M538530 2014-09-04T21:29:18Z Re: Question: Common Percentage in Line Graph for Multiple Items https://community.qlik.com/t5/QlikView/Question-Common-Percentage-in-Line-Graph-for-Multiple-Items/m-p/713019#M538531 <HTML><HEAD></HEAD><BODY><P>Maybe. If you post an example document that demonstrates the problem perhaps somebody can help you. If you want to try to figure it our yourself then investigate the <STRONG>total</STRONG> option for aggregation functions: sum(<STRONG>total &lt;<EM>DimA</EM>&gt;</STRONG> Amount). My guess is that you'll need that total option somewhere in your expression(s).</P></BODY></HTML> Fri, 05 Sep 2014 06:40:14 GMT https://community.qlik.com/t5/QlikView/Question-Common-Percentage-in-Line-Graph-for-Multiple-Items/m-p/713019#M538531 Gysbert_Wassenaar 2014-09-05T06:40:14Z