topic Memory Variable Script in QlikView

Memory Variable Script

tracycrown — Wed, 25 Nov 2020 16:16:04 GMT

Dear all

Kindly advise how to write a simple script to store the record numbers (Period) and values (Sales) of first & last records as memory variables for Period (P1=1 & P2=16) and Sales (T1=4.8 & T2=8.4).

Thank you

Tracy

Re: Memory Variable Script

rubenmarin — Sun, 30 Dec 2018 17:41:14 GMT

Hi Tracy, if you add a condition to retrieve only files with sales:

Where Len(Trim(Sales))>0;

The variables can be created like:

LET P1 = Peek('t',0,'Sales');
LET T1 = Peek('Sales',0,'Sales');
LET P2 = Peek('t',NoOfRows('Sales')-1,'Sales');
LET T2 = Peek('Sales',NoOfRows('Sales')-1,'Sales');

Re: Memory Variable Script

tracycrown — Mon, 31 Dec 2018 03:11:31 GMT

Dear Rubenmarin
Thank you so much for your help, you are very helpful.
Wishing you and your family a Happy, Healthy and Prosperous New Year 2019.
Tracy