topic How to use/create a Scriptvariable via LOAD in QlikView https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193727#M503451 <HTML><HEAD></HEAD><BODY><P>Go to "Reply" ==&gt; Options ==&gt; Add/Update</P><P>Rainer</P></BODY></HTML> Fri, 18 Jun 2010 10:49:44 GMT 2010-06-18T10:49:44Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193720#M503435 <HTML><HEAD></HEAD><BODY><P></P><P></P><P></P><P>Hi, how can I use OLDFIRSTOCCURENCE as an Scriptvariable?</P><P>LOAD<BR />MaxString(Status.FIRSTOCCURRENCE) as OLDFIRSTOCCURRENCE<BR />FROM status.qvd (qvd);</P><P>I already tested:</P><P></P><P>let OLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE');</P><P>but it doesn't work!</P><P>best regards<BR />Ingo Placzek</P><BR /><BR /></BODY></HTML> Fri, 18 Jun 2010 06:08:13 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193720#M503435 2010-06-18T06:08:13Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193721#M503441 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the correct definition is:</P><P>Let varOLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE', 0, 'TableName');</P><P>See QV help for more details.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Fri, 18 Jun 2010 06:30:43 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193721#M503441 2010-06-18T06:30:43Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193722#M503444 <HTML><HEAD></HEAD><BODY><P>Hi, I write it like this, but varOLDFIRSTOCCURRENCE is empty.but in an listbox, he shows me the value.</P><P>Statustime:<BR />LOAD<BR /> MaxString(Status.FIRSTOCCURRENCE) as OLDFIRSTOCCURRENCE<BR />FROM statustime.qvd (qvd);</P><P>let varOLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE',0,'Statustime');</P></BODY></HTML> Fri, 18 Jun 2010 07:19:08 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193722#M503444 2010-06-18T07:19:08Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193723#M503446 <HTML><HEAD></HEAD><BODY><P>Hello Ingo,</P><P>It's happening to me, and I work around that doing instead</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">FieldValue('OLDFIRSTOCCURRENCE', 1)</PRE></BLOCKQUOTE>Which version of QV are you using?<BR /><BR /></BODY></HTML> Fri, 18 Jun 2010 07:31:26 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193723#M503446 Miguel_Angel_Baeyens 2010-06-18T07:31:26Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193724#M503448 <HTML><HEAD></HEAD><BODY><P>im workin with 9.00 SR4 too, but it dowsnt work if I write:</P><P>let varOLDFIRSTOCCURRENCE = FieldValue('OLDFIRSTOCCURRENCE', 1)</P><P>the value is &lt;NULL&gt; like before with peek</P></BODY></HTML> Fri, 18 Jun 2010 07:37:41 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193724#M503448 2010-06-18T07:37:41Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193725#M503449 <HTML><HEAD></HEAD><BODY><P>Hi Ingo,</P><P>please upload some sample data.</P><P>I used this kind of statement very often and it worked well.</P><P>Rainer</P></BODY></HTML> Fri, 18 Jun 2010 09:53:25 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193725#M503449 2010-06-18T09:53:25Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193726#M503450 <HTML><HEAD></HEAD><BODY><P>in FIRSTOCCURRENCE are timestamps like: 2010-02-20 04:00:01.000000</P><P>how can i upload qvd files?</P></BODY></HTML> Fri, 18 Jun 2010 10:13:20 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193726#M503450 2010-06-18T10:13:20Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193727#M503451 <HTML><HEAD></HEAD><BODY><P>Go to "Reply" ==&gt; Options ==&gt; Add/Update</P><P>Rainer</P></BODY></HTML> Fri, 18 Jun 2010 10:49:44 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193727#M503451 2010-06-18T10:49:44Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193728#M503452 <HTML><HEAD></HEAD><BODY><P>Hi, here is the qvd-file</P></BODY></HTML> Fri, 18 Jun 2010 10:51:23 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193728#M503452 2010-06-18T10:51:23Z How to use/create a Scriptvariable via LOAD https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193729#M503453 <HTML><HEAD></HEAD><BODY><P>Hi Ingo,</P><P>hope your problem is solved now.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Fri, 18 Jun 2010 11:19:30 GMT https://community.qlik.com/t5/QlikView/How-to-use-create-a-Scriptvariable-via-LOAD/m-p/193729#M503453 2010-06-18T11:19:30Z