topic Re: LET Statement value directly assign the load statement in QlikView https://community.qlik.com/t5/QlikView/LET-Statement-value-directly-assign-the-load-statement/m-p/469647#M1155998 <HTML><HEAD></HEAD><BODY><P><STRONG style=": ; color: #0000ff; font-size: 8pt;">&nbsp; </STRONG></P><P>Load * inline </P><P>[</P><P>eDate,sDate</P><P>$(vEndDate), $(vStartDate)</P><P>];</P></BODY></HTML> Tue, 26 Feb 2013 06:17:45 GMT 2013-02-26T06:17:45Z LET Statement value directly assign the load statement https://community.qlik.com/t5/QlikView/LET-Statement-value-directly-assign-the-load-statement/m-p/469646#M1155997 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: 0.0001pt;"><SPAN style="color: #000000; font-family: 'book antiqua', palatino;">Hi All,</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="color: #000000; font-family: 'book antiqua', palatino;"> </SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="color: #000000; font-size: 9pt; font-family: 'book antiqua', palatino;">Able to assign the LET statement state value in load statement, </SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: 'book antiqua', palatino;">please help me,</SPAN></P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="color: #000000; font-size: 9pt; font-family: 'book antiqua', palatino;">For Ex,</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="color: #000000; font-family: 'book antiqua', palatino;"> </SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="color: #000000; font-family: 'book antiqua', palatino;"><SPAN style="font-size: 9pt;">LET</SPAN> <EM style="font-size: 9pt;">vEndDate</EM><SPAN style="font-size: 9pt;">&nbsp;&nbsp; = </SPAN><SPAN style="font-size: 9pt;">num</SPAN><SPAN style="font-size: 9pt;">(</SPAN><SPAN style="font-size: 9pt;">today</SPAN><SPAN style="font-size: 9pt;">(1)+365);&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-size: 9pt;">// End at today's date plus 1 year<BR /></SPAN><SPAN style="font-size: 9pt;">LET</SPAN> <EM style="font-size: 9pt;">vStartDate</EM><SPAN style="font-size: 9pt;"> = </SPAN><SPAN style="font-size: 9pt;">num</SPAN><SPAN style="font-size: 9pt;">(</SPAN><SPAN style="font-size: 9pt;">today</SPAN><SPAN style="font-size: 9pt;">(1)-365);&nbsp; </SPAN><SPAN style="font-size: 9pt;">// Start a year ago. </SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-family: 'book antiqua', palatino;">Load * inline </SPAN></P><P><SPAN style="color: #000000; font-family: 'book antiqua', palatino;">[</SPAN></P><P><SPAN style="color: #000000; font-family: 'book antiqua', palatino;">eDate,sDate</SPAN></P><P><SPAN style="color: #000000; font-family: 'book antiqua', palatino;"><EM style="font-size: 9pt;">vEndDate, vStartDate</EM></SPAN></P><P><SPAN style="color: #000000; font-family: 'book antiqua', palatino;">];</SPAN></P><P></P><P><SPAN style="font-family: 'book antiqua', palatino;">Regards,</SPAN></P><P><SPAN style="font-family: 'book antiqua', palatino;">Senthil...</SPAN></P></BODY></HTML> Tue, 26 Feb 2013 06:12:32 GMT https://community.qlik.com/t5/QlikView/LET-Statement-value-directly-assign-the-load-statement/m-p/469646#M1155997 2013-02-26T06:12:32Z Re: LET Statement value directly assign the load statement https://community.qlik.com/t5/QlikView/LET-Statement-value-directly-assign-the-load-statement/m-p/469647#M1155998 <HTML><HEAD></HEAD><BODY><P><STRONG style=": ; color: #0000ff; font-size: 8pt;">&nbsp; </STRONG></P><P>Load * inline </P><P>[</P><P>eDate,sDate</P><P>$(vEndDate), $(vStartDate)</P><P>];</P></BODY></HTML> Tue, 26 Feb 2013 06:17:45 GMT https://community.qlik.com/t5/QlikView/LET-Statement-value-directly-assign-the-load-statement/m-p/469647#M1155998 2013-02-26T06:17:45Z Re: LET Statement value directly assign the load statement https://community.qlik.com/t5/QlikView/LET-Statement-value-directly-assign-the-load-statement/m-p/469648#M1155999 <HTML><HEAD></HEAD><BODY><P>Hi Yaseen,</P><P></P><P>Thanking you...</P><P></P><P>Regards,</P><P>Senthil..</P></BODY></HTML> Tue, 26 Feb 2013 06:36:12 GMT https://community.qlik.com/t5/QlikView/LET-Statement-value-directly-assign-the-load-statement/m-p/469648#M1155999 2013-02-26T06:36:12Z