topic Re: calculating % in trend graph in QlikView https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287045#M402891 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">There is field for exclusion. For the expression</SPAN></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Sorry, but I have no idea what you're trying to tell me here.</P></BODY></HTML> Sat, 07 Jan 2017 07:35:27 GMT Gysbert_Wassenaar 2017-01-07T07:35:27Z calculating % in trend graph https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287042#M402888 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Find qvw file. How can i use listbox to exclude items in trending line chart.</P><P></P><P>Emar</P></BODY></HTML> Fri, 06 Jan 2017 16:43:50 GMT https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287042#M402888 2017-01-06T16:43:50Z Re: calculating % in trend graph https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287043#M402889 <HTML><HEAD></HEAD><BODY><P>Perhaps with this expression: Count ({&lt;Function = E(Function)&gt;} Item)/ Count ({&lt;Function&gt;} Item)*100</P></BODY></HTML> Fri, 06 Jan 2017 17:43:12 GMT https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287043#M402889 Gysbert_Wassenaar 2017-01-06T17:43:12Z Re: calculating % in trend graph https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287044#M402890 <HTML><HEAD></HEAD><BODY><P>There is field for exclusion. For the expression</P></BODY></HTML> Fri, 06 Jan 2017 20:04:45 GMT https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287044#M402890 2017-01-06T20:04:45Z Re: calculating % in trend graph https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287045#M402891 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">There is field for exclusion. For the expression</SPAN></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Sorry, but I have no idea what you're trying to tell me here.</P></BODY></HTML> Sat, 07 Jan 2017 07:35:27 GMT https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287045#M402891 Gysbert_Wassenaar 2017-01-07T07:35:27Z Re: calculating % in trend graph https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287046#M402892 <HTML><HEAD></HEAD><BODY><P>One of the expressions holds complete % of all item except "None" why the other expression works with the exclusion list-box such that when an option is checked it increases the %. Also date is my default dimension. </P></BODY></HTML> Sat, 07 Jan 2017 20:24:28 GMT https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287046#M402892 2017-01-07T20:24:28Z Re: calculating % in trend graph https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287047#M402893 <HTML><HEAD></HEAD><BODY><P>Sorry, this is getting more confusing instead of less. I have no idea anymore what problem you're trying to solve.</P></BODY></HTML> Mon, 09 Jan 2017 17:55:45 GMT https://community.qlik.com/t5/QlikView/calculating-in-trend-graph/m-p/1287047#M402893 Gysbert_Wassenaar 2017-01-09T17:55:45Z