topic Average without considering the current selections in QlikView https://community.qlik.com/t5/QlikView/Average-without-considering-the-current-selections/m-p/1224424#M391050 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">hello, I am trying to <SPAN>create a document</SPAN> to manage a fleet vehicles.<BR />I have a problem <SPAN>in dealing with the</SPAN> total average of the values on a monthly basis without considering the current selections. Now I managed to make the average dividend for the months numbers and color the cells if the values exceed 40% or 60%, the problem is that <SPAN>not all of the</SPAN> "plate" fields have monthly values so the media is not correct and especially <SPAN>if I change</SPAN> the selections change my media.<BR />I wish the total average <SPAN>of all the years</SPAN> that is the total sum divided by the number of months the single "plate".<BR />I attach <SPAN>an example</SPAN>, and <SPAN>I hope I was</SPAN> clear <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" />.<BR />Thank you</SPAN></P></BODY></HTML> Tue, 07 Feb 2017 08:12:58 GMT 2017-02-07T08:12:58Z Average without considering the current selections https://community.qlik.com/t5/QlikView/Average-without-considering-the-current-selections/m-p/1224424#M391050 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">hello, I am trying to <SPAN>create a document</SPAN> to manage a fleet vehicles.<BR />I have a problem <SPAN>in dealing with the</SPAN> total average of the values on a monthly basis without considering the current selections. Now I managed to make the average dividend for the months numbers and color the cells if the values exceed 40% or 60%, the problem is that <SPAN>not all of the</SPAN> "plate" fields have monthly values so the media is not correct and especially <SPAN>if I change</SPAN> the selections change my media.<BR />I wish the total average <SPAN>of all the years</SPAN> that is the total sum divided by the number of months the single "plate".<BR />I attach <SPAN>an example</SPAN>, and <SPAN>I hope I was</SPAN> clear <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" />.<BR />Thank you</SPAN></P></BODY></HTML> Tue, 07 Feb 2017 08:12:58 GMT https://community.qlik.com/t5/QlikView/Average-without-considering-the-current-selections/m-p/1224424#M391050 2017-02-07T08:12:58Z