topic Re: Master Item Function - Average of Total in App Development https://community.qlik.com/t5/App-Development/Master-Item-Function-Average-of-Total/m-p/1066583#M17316 <HTML><HEAD></HEAD><BODY><P>My goal is to display the chart like this:</P><P></P><P><IMG alt="Output - Average.PNG" class="jive-image image-1" src="/legacyfs/online/111267_Output - Average.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 11 Jan 2016 17:46:06 GMT 2016-01-11T17:46:06Z Master Item Function - Average of Total https://community.qlik.com/t5/App-Development/Master-Item-Function-Average-of-Total/m-p/1066582#M17315 <HTML><HEAD></HEAD><BODY><P>I need a master item which will function as an If statement. </P><P></P><P><IMG alt="Vendor Small.PNG" class="jive-image image-1" src="/legacyfs/online/111266_Vendor Small.PNG" style="height: 309px; width: 620px;" /></P><P>I have a series of values, each with a yes of a no. How do I add a master item which would tell, if yes for column A, then total. That total would then need to be divided the total of every possible value. So ideally it would would give you percentage of spend fulling under that specific category. </P><P></P><P>I am not able to adjust the excel sheet, or I would just make the changes there. Even when I try to do a simple average master item it says it is an invalid dimension.</P><P></P><P>Your help is most appreciated</P></BODY></HTML> Mon, 11 Jan 2016 17:44:57 GMT https://community.qlik.com/t5/App-Development/Master-Item-Function-Average-of-Total/m-p/1066582#M17315 2016-01-11T17:44:57Z Re: Master Item Function - Average of Total https://community.qlik.com/t5/App-Development/Master-Item-Function-Average-of-Total/m-p/1066583#M17316 <HTML><HEAD></HEAD><BODY><P>My goal is to display the chart like this:</P><P></P><P><IMG alt="Output - Average.PNG" class="jive-image image-1" src="/legacyfs/online/111267_Output - Average.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 11 Jan 2016 17:46:06 GMT https://community.qlik.com/t5/App-Development/Master-Item-Function-Average-of-Total/m-p/1066583#M17316 2016-01-11T17:46:06Z