topic Re: Set Analysis Help in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/918741#M987178 <HTML><HEAD></HEAD><BODY><P>Please post the sample app or data</P></BODY></HTML> Tue, 28 Jul 2015 18:57:53 GMT Kushal_Chawda 2015-07-28T18:57:53Z Set Analysis Help https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/918740#M987177 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>I am having difficulty creating a couple statements to help work with my current data set.&nbsp; First objective is to have the blue bar be the sum operating score between the company, sector, and sub-sector.&nbsp; The second is to have the red bar be the avg operating score between the company, sector, and sub-sector selected.</P><P></P><P>Restrictions -</P><P>1. Company must be selected first.</P><P>2. Then we need to benchmark it against overall average and then give a user the option to drill down by the sector and sub-sector.</P><P></P><P>Please let me know if you need more detail!&nbsp; I really need some help with this!</P><P></P><P>Example,</P><P></P><P>If I select Sector Health and Sub-sector Health - Phama, my red bar should reflect the avg between the two selections (2) and my blue bar should reflect the total sum of the selections (4)</P><P></P><P></P><P><IMG __jive_id="94325" alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94325_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 28 Jul 2015 18:54:03 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/918740#M987177 2015-07-28T18:54:03Z Re: Set Analysis Help https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/918741#M987178 <HTML><HEAD></HEAD><BODY><P>Please post the sample app or data</P></BODY></HTML> Tue, 28 Jul 2015 18:57:53 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/918741#M987178 Kushal_Chawda 2015-07-28T18:57:53Z