topic Re: Qlikview script not working correctly . in QlikView https://community.qlik.com/t5/QlikView/Qlikview-script-not-working-correctly/m-p/1311378#M833594 <HTML><HEAD></HEAD><BODY><P>because your Distributor_Link field is not associated to your data model </P></BODY></HTML> Mon, 05 Jun 2017 14:20:33 GMT vinieme12 2017-06-05T14:20:33Z Qlikview script not working correctly . https://community.qlik.com/t5/QlikView/Qlikview-script-not-working-correctly/m-p/1311376#M833592 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>Please advise why the product is allocating to NULL distributor as though the distributor should be 'PIN' with qty_avaiable '32868' for warehouse 'W10'.<IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165777_Capture1.PNG" style="height: 143px; width: 620px;" /></P><P></P><P></P><P></P><P></P><P><IMG alt="Capture2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/165778_Capture2.PNG" style="height: auto;" /></P><P></P><P>sample attached.</P><P></P><P></P><P>Please advise why the "Prev 3 month sales units " is not working in the sample model.</P><P></P><P><IMG alt="Capture3.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/165780_Capture3.PNG" style="height: 145px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Qlikview-script-not-working-correctly/m-p/1311376#M833592 suvechha_b 2020-11-25T16:16:04Z Re: Qlikview script not working correctly . https://community.qlik.com/t5/QlikView/Qlikview-script-not-working-correctly/m-p/1311377#M833593 <HTML><HEAD></HEAD><BODY><P>As i stated before,</P><P><A _jive_internal="true" href="https://community.qlik.com/thread/262901" style="font-size: 10pt;" title="https://community.qlik.com/thread/262901">https://community.qlik.com/thread/262901</A></P><P>the period_key on the table doesn't have the necessary values for the expression your calculating (see the image below, with the markings).</P><P></P><P>You have to understand in your data, as to why only period_key with value 190 is being loaded.</P><P></P><P><IMG alt="Sample2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165791_Sample2.png" style="height: 349px; width: 620px;" /></P><P></P><P>Felipe.</P></BODY></HTML> Mon, 05 Jun 2017 14:16:19 GMT https://community.qlik.com/t5/QlikView/Qlikview-script-not-working-correctly/m-p/1311377#M833593 felipedl 2017-06-05T14:16:19Z Re: Qlikview script not working correctly . https://community.qlik.com/t5/QlikView/Qlikview-script-not-working-correctly/m-p/1311378#M833594 <HTML><HEAD></HEAD><BODY><P>because your Distributor_Link field is not associated to your data model </P></BODY></HTML> Mon, 05 Jun 2017 14:20:33 GMT https://community.qlik.com/t5/QlikView/Qlikview-script-not-working-correctly/m-p/1311378#M833594 vinieme12 2017-06-05T14:20:33Z