topic Help required in getting the required output in a variable. in QlikView https://community.qlik.com/t5/QlikView/Help-required-in-getting-the-required-output-in-a-variable/m-p/1188326#M384186 <HTML><HEAD></HEAD><BODY><P>I have below 2 table which contains columns as mentioned below.</P><P></P><P><STRONG>Existing_Files:</STRONG></P><P></P><P></P><P>File Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QVD_DATE<BR />-----------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----------------</P><P>C:\ProgramFiles\QVD\Employee_M.2016_05.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_05<BR />C:\ProgramFiles\QVD\Employee_M.2016_06.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_06</P><P></P><P><STRONG>New_Files:</STRONG></P><P></P><P>NEW_DATE<BR />----------------<BR />2016_07</P><P></P><P>So what we need is if 2016_07 does not exists in Existing_Files table then value in the variable should be zNewDates='2016_07','2016_06'.</P><P></P><P>If 2016_07 already exists in the Existing_Files table like below then the value in the varialble should be zNewDates='2016_07'</P><P><BR /><STRONG>Existing_Files:</STRONG></P><P>File Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QVD_DATE<BR />-----------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----------------</P><P>C:\ProgramFiles\QVD\Employee_M.2016_05.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_05<BR />C:\ProgramFiles\QVD\Employee_M.2016_06.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_06<BR />C:\ProgramFiles\QVD\Employee_M.2016_07.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_07</P><P></P><P><STRONG>New_Files:</STRONG></P><P>NEW_DATE<BR />----------------<BR />2016_07</P><P></P><P></P><P>Can someone help me to get the required output?</P></BODY></HTML> Tue, 20 Sep 2016 07:56:16 GMT qlikviewforum 2016-09-20T07:56:16Z Help required in getting the required output in a variable. https://community.qlik.com/t5/QlikView/Help-required-in-getting-the-required-output-in-a-variable/m-p/1188326#M384186 <HTML><HEAD></HEAD><BODY><P>I have below 2 table which contains columns as mentioned below.</P><P></P><P><STRONG>Existing_Files:</STRONG></P><P></P><P></P><P>File Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QVD_DATE<BR />-----------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----------------</P><P>C:\ProgramFiles\QVD\Employee_M.2016_05.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_05<BR />C:\ProgramFiles\QVD\Employee_M.2016_06.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_06</P><P></P><P><STRONG>New_Files:</STRONG></P><P></P><P>NEW_DATE<BR />----------------<BR />2016_07</P><P></P><P>So what we need is if 2016_07 does not exists in Existing_Files table then value in the variable should be zNewDates='2016_07','2016_06'.</P><P></P><P>If 2016_07 already exists in the Existing_Files table like below then the value in the varialble should be zNewDates='2016_07'</P><P><BR /><STRONG>Existing_Files:</STRONG></P><P>File Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QVD_DATE<BR />-----------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----------------</P><P>C:\ProgramFiles\QVD\Employee_M.2016_05.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_05<BR />C:\ProgramFiles\QVD\Employee_M.2016_06.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_06<BR />C:\ProgramFiles\QVD\Employee_M.2016_07.qvd&nbsp;&nbsp;&nbsp;&nbsp; 2016_07</P><P></P><P><STRONG>New_Files:</STRONG></P><P>NEW_DATE<BR />----------------<BR />2016_07</P><P></P><P></P><P>Can someone help me to get the required output?</P></BODY></HTML> Tue, 20 Sep 2016 07:56:16 GMT https://community.qlik.com/t5/QlikView/Help-required-in-getting-the-required-output-in-a-variable/m-p/1188326#M384186 qlikviewforum 2016-09-20T07:56:16Z Re: Help required in getting the required output in a variable. https://community.qlik.com/t5/QlikView/Help-required-in-getting-the-required-output-in-a-variable/m-p/1188327#M384187 <HTML><HEAD></HEAD><BODY><P>What is your objective? Do you want to load the latest file?</P><P></P><P><A href="https://community.qlik.com/thread/75751">how to Load only the latest files?</A></P><P><A href="https://community.qlik.com/docs/DOC-8912">Load latest Excel file to Qlikview</A></P></BODY></HTML> Tue, 20 Sep 2016 08:04:44 GMT https://community.qlik.com/t5/QlikView/Help-required-in-getting-the-required-output-in-a-variable/m-p/1188327#M384187 MK_QSL 2016-09-20T08:04:44Z Re: Help required in getting the required output in a variable. https://community.qlik.com/t5/QlikView/Help-required-in-getting-the-required-output-in-a-variable/m-p/1188328#M384188 <HTML><HEAD></HEAD><BODY><P>The objective here is, we receive the data on weekly basis but we store it as a monthly qvd. So in some cases we receive 2 months data in one month but the proc_date date will be the latest date. </P><P></P><P>If we receive data for 27th Jun to 1st Jul and the proc_date here is 1st Jul. Since we generate the monthly QVD based on the proc_date. In this case it will generate only Jul month qvd and it will not generate jun month qvd again. So transact for 27thjun to 30th jun will be lost. </P><P></P><P>So take care of this we need to create this block and so that whenever the new month comes it generates previous month as well as new month.</P><P></P><P>Let me know if you have any questions.</P></BODY></HTML> Tue, 20 Sep 2016 09:53:39 GMT https://community.qlik.com/t5/QlikView/Help-required-in-getting-the-required-output-in-a-variable/m-p/1188328#M384188 qlikviewforum 2016-09-20T09:53:39Z