topic logic problem in QlikView https://community.qlik.com/t5/QlikView/logic-problem/m-p/700951#M253039 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have storage plant and plant stock two fields</P><P></P><P>In the year 2014 I have 7 storage plants and when I select 2014 april I have only 4 storage plants and remaining 3 are missing that is Null it is not specifeid in the data base. for the Null values I need to take from the previous Month that contains the value that maybe 0 or anything</P><P>For example</P><P></P><P>2014&nbsp;&nbsp;&nbsp;&nbsp; plant stock</P><P>tab&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 454&nbsp;&nbsp;&nbsp;&nbsp; </P><P>taj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222&nbsp;&nbsp;&nbsp;&nbsp; </P><P>tam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 554&nbsp;&nbsp;&nbsp;&nbsp; </P><P>yrj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 878&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>tje&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 986&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>fjfs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 665</P><P></P><P></P><P>April2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Plantstock</P><P>tab&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 88&nbsp;&nbsp;&nbsp;&nbsp; </P><P>taj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96&nbsp;&nbsp;&nbsp;&nbsp; </P><P>tam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54</P><P></P><P>here YRJ TJE and FJFS are missing so i want to search in the previous month for that storageplant has value or not</P></BODY></HTML> Thu, 03 Jul 2014 06:50:03 GMT 2014-07-03T06:50:03Z logic problem https://community.qlik.com/t5/QlikView/logic-problem/m-p/700951#M253039 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have storage plant and plant stock two fields</P><P></P><P>In the year 2014 I have 7 storage plants and when I select 2014 april I have only 4 storage plants and remaining 3 are missing that is Null it is not specifeid in the data base. for the Null values I need to take from the previous Month that contains the value that maybe 0 or anything</P><P>For example</P><P></P><P>2014&nbsp;&nbsp;&nbsp;&nbsp; plant stock</P><P>tab&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 454&nbsp;&nbsp;&nbsp;&nbsp; </P><P>taj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222&nbsp;&nbsp;&nbsp;&nbsp; </P><P>tam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 554&nbsp;&nbsp;&nbsp;&nbsp; </P><P>yrj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 878&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>tje&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 986&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>fjfs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 665</P><P></P><P></P><P>April2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Plantstock</P><P>tab&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 88&nbsp;&nbsp;&nbsp;&nbsp; </P><P>taj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96&nbsp;&nbsp;&nbsp;&nbsp; </P><P>tam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54</P><P></P><P>here YRJ TJE and FJFS are missing so i want to search in the previous month for that storageplant has value or not</P></BODY></HTML> Thu, 03 Jul 2014 06:50:03 GMT https://community.qlik.com/t5/QlikView/logic-problem/m-p/700951#M253039 2014-07-03T06:50:03Z Re: logic problem https://community.qlik.com/t5/QlikView/logic-problem/m-p/700952#M253040 <HTML><HEAD></HEAD><BODY><P>Can you post an example document with some data?</P></BODY></HTML> Thu, 03 Jul 2014 12:32:12 GMT https://community.qlik.com/t5/QlikView/logic-problem/m-p/700952#M253040 Gysbert_Wassenaar 2014-07-03T12:32:12Z