topic Re: Expression not working in QlikView https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198621#M883562 <HTML><HEAD></HEAD><BODY><P>Does it possible to share the expression, I don't have license software by hand</P></BODY></HTML> Mon, 03 Oct 2016 13:40:10 GMT Anil_Babu_Samineni 2016-10-03T13:40:10Z Expression not working https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198619#M883560 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>Please help me to get the expression correctly for "Days Cover per FC".</P><P></P><P>When , I am selecting specific product the "Days Cover per FC" is pulling correctly but if I don't select any product the value is wrong .</P><P></P><P>Sample model attached.</P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139442_Capture1.PNG" style="height: 174px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198619#M883560 suvechha_b 2020-11-25T16:16:04Z Re: Expression not working https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198620#M883561 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>As you're using TOTAL in your expression, the "Days Cover per FC" will change according your selection.</P><P>Why are you using it?</P></BODY></HTML> Mon, 03 Oct 2016 13:10:40 GMT https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198620#M883561 Marcio_Campestrini 2016-10-03T13:10:40Z Re: Expression not working https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198621#M883562 <HTML><HEAD></HEAD><BODY><P>Does it possible to share the expression, I don't have license software by hand</P></BODY></HTML> Mon, 03 Oct 2016 13:40:10 GMT https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198621#M883562 Anil_Babu_Samineni 2016-10-03T13:40:10Z Re: Expression not working https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198622#M883563 <HTML><HEAD></HEAD><BODY><P>Hi, try this expression:</P><P>Sum(Aggr((sum(stock_on_hand)/(SUM( {&lt;&nbsp; period_key = {"&lt;=$(vPrevPeriod1)&gt;=$(vPrevPeriod6)"} &gt;}sales_plan) /6))*(22),[Product Code]))</P><P></P><P>This is the output:</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139434_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Regards!!</P></BODY></HTML> Mon, 03 Oct 2016 14:03:50 GMT https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1198622#M883563 Anonymous 2016-10-03T14:03:50Z