topic Re: QVD in QlikView

topic Re: QVD in QlikView https://community.qlik.com/t5/QlikView/QVD/m-p/1031805#M348280 <HTML><HEAD></HEAD><BODY><P>You can load multiple QVDs using wildcard characters.  check below link</P><P></P><P><A href="https://community.qlik.com/docs/DOC-6668">Loading Multiple QVD files</A></P></BODY></HTML> Mon, 21 Mar 2016 04:21:32 GMT jagan 2016-03-21T04:21:32Z QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031800#M348275 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>How to store data into QVD's Monthly wise.</P><P></P><P></P><P>Thanks</P></BODY></HTML> Mon, 21 Mar 2016 03:15:58 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031800#M348275 2016-03-21T03:15:58Z Re: QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031801#M348276 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this, You can just change your Date / Month Field</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P style="margin-bottom: .0001pt;"><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">DIRECTORY</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> ;<BR /> Test:<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">MonthName</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Date</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">MonthYear</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,*;<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Date</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">('1/1/2015'+</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">IterNo</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">()-1) </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Date</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">AutoGenerate</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> 1 </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">While</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">IterNo</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">()<=365;<BR /> <BR /> Check:<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Load</STRONG> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Distinct</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Monthname</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Date</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Month</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Resident</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> Test;<BR /> <BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">let</STRONG> <STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">vCount</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> = </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">NoOfRows</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">('Check');<BR /> <BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">For</STRONG> <STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">i</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=0 </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">to</SPAN> <STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">$(vCount)</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> -1<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Let</STRONG> <STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">vMonth</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> = </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Peek</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">('Month',</SPAN><STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">$(i)</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,'Month');  <BR /> [$(vMonth)]:<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Load</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> *,'$(vMonth)' </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Month1</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Resident</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> Test </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">where</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">MonthName</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Date</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) = '$(vMonth)'; <BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Store</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> [$(vMonth)] </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">into</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> [$(vMonth)].qvd;<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Drop</STRONG> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">table</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> [$(vMonth)];   <BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">NEXT</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> <BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Drop</STRONG> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">table</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> Check; </SPAN></P> <P></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML> Mon, 21 Mar 2016 03:45:31 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031801#M348276 settu_periasamy 2016-03-21T03:45:31Z Re: QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031802#M348277 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check these links too..</P><P></P><P><A href="https://community.qlikview.com/thread/95211" title="https://community.qlikview.com/thread/95211">Create Monthly QVD's | Qlik Community</A></P><P><A href="https://community.qlikview.com/thread/167277" title="https://community.qlikview.com/thread/167277">storing data into qvd in monthly basis | Qlik Community</A></P></BODY></HTML> Mon, 21 Mar 2016 03:47:33 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031802#M348277 settu_periasamy 2016-03-21T03:47:33Z Re: QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031803#M348278 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this link, hope it helps you.</P><P></P><P><A href="https://community.qlikview.com/thread/167277" title="https://community.qlikview.com/thread/167277">storing data into qvd in monthly basis | Qlik Community</A></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 21 Mar 2016 04:16:42 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031803#M348278 jagan 2016-03-21T04:16:42Z Re: QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031804#M348279 <HTML><HEAD></HEAD><BODY><P>Once generating the QVD for past data by month, then you have to generate the latest QVD for the new months like below.</P><P></P><P>Data:</P><P>LOAD</P><P>*</P><P>FROM DataSource</P><P>WHERE MonthName(DateFieldName) = MonthName(Today());</P><P></P><P>LET vMonthname = MonthName(Today());</P><P></P><P></P><P>STORE Data INTO [DATA_$(vMonthname).qvd];</P><P></P><P>Hope this helps you</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 21 Mar 2016 04:18:43 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031804#M348279 jagan 2016-03-21T04:18:43Z Re: QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031805#M348280 <HTML><HEAD></HEAD><BODY><P>You can load multiple QVDs using wildcard characters.  check below link</P><P></P><P><A href="https://community.qlik.com/docs/DOC-6668">Loading Multiple QVD files</A></P></BODY></HTML> Mon, 21 Mar 2016 04:21:32 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031805#M348280 jagan 2016-03-21T04:21:32Z Re: QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031806#M348281 <HTML><HEAD></HEAD><BODY><P>check this threads too</P><P><A href="https://community.qlik.com/thread/95211">Create Monthly QVD's</A></P><P><A href="https://community.qlik.com/thread/179174">Monthly Qvd</A></P></BODY></HTML> Mon, 21 Mar 2016 05:13:01 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031806#M348281 avinashelite 2016-03-21T05:13:01Z Re: QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031807#M348282 <HTML><HEAD></HEAD><BODY><P>chk dis too</P><P><A href="https://community.qlik.com/message/99941">QVDs creation?</A></P></BODY></HTML> Mon, 21 Mar 2016 05:15:04 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031807#M348282 Chanty4u 2016-03-21T05:15:04Z Re: QVD https://community.qlik.com/t5/QlikView/QVD/m-p/1031808#M348283 <HTML><HEAD></HEAD><BODY><P>Thank You All</P></BODY></HTML> Mon, 21 Mar 2016 06:08:00 GMT https://community.qlik.com/t5/QlikView/QVD/m-p/1031808#M348283 2016-03-21T06:08:00Z