topic Re: How to hide allocations in QlikView https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329872#M410945 <HTML><HEAD></HEAD><BODY><P>Yes in this case since everyone is fully allocated in January. Of course, if someone is allocated say 0.8 in total in January, that allocation should be kept. </P></BODY></HTML> Wed, 07 Jun 2017 18:11:40 GMT posywang 2017-06-07T18:11:40Z How to hide allocations https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329870#M410943 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to hide project allocations if resource is fully allocated to projects as 1 FTE. However, I am not able to hide allocations at a lower level, project level in this case. Is there a way to hide highlighted numbers when Show Variance button is clicked? Thanks!</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166111_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 07 Jun 2017 17:57:06 GMT https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329870#M410943 posywang 2017-06-07T17:57:06Z Re: How to hide allocations https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329871#M410944 <HTML><HEAD></HEAD><BODY><P>The complete column should go away?</P></BODY></HTML> Wed, 07 Jun 2017 18:03:06 GMT https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329871#M410944 sunny_talwar 2017-06-07T18:03:06Z Re: How to hide allocations https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329872#M410945 <HTML><HEAD></HEAD><BODY><P>Yes in this case since everyone is fully allocated in January. Of course, if someone is allocated say 0.8 in total in January, that allocation should be kept. </P></BODY></HTML> Wed, 07 Jun 2017 18:11:40 GMT https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329872#M410945 posywang 2017-06-07T18:11:40Z Re: How to hide allocations https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329873#M410946 <HTML><HEAD></HEAD><BODY><P>Try this expression</P><P><STRONG>=If(Sum(TOTAL &lt;Resource, Mth&gt; FTE)=1,0,Sum(FTE))</STRONG></P></BODY></HTML> Wed, 07 Jun 2017 18:13:26 GMT https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329873#M410946 sunny_talwar 2017-06-07T18:13:26Z Re: How to hide allocations https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329874#M410947 <HTML><HEAD></HEAD><BODY><P>Thanks! Works like a charm!</P></BODY></HTML> Wed, 07 Jun 2017 18:15:48 GMT https://community.qlik.com/t5/QlikView/How-to-hide-allocations/m-p/1329874#M410947 posywang 2017-06-07T18:15:48Z