topic Re: Re: Loop through table values to input into a procedure in QlikView

Loop through table values to input into a procedure

paulm — Thu, 06 Feb 2014 16:37:02 GMT

Hi,

I am trying to do a bit of repetitive work through a procedure. The procedure itself works fine, but when trying to feed in values I am getting null values. Below is the code, pretty sure its a simple mistake, so any help would be great.

LIST:
LOAD * INLINE [
    Table Name, Search Value, First Wild, Second Wild, Tag
    MONTHLY_LEU, PSO, *, *, PSO
    MONTHLY_LEU, Imperfections Charge¬, *, *, IMPERFECTIONS
    MONTHLY_LEU, Total Units, , *, POPULAR
    MONTHLY_LEU, Moyle Interconnector Charge, *, *, MOYLE
    MONTHLY_LEU, Availability Charge, *, *, AVAIL
    MONTHLY_LEU, CCL¬, *, *, CCL
    MONTHLY_LEU, SCC¬, *, *, SCC
    MONTHLY_LEU, Monthly Charge¬, *, *, MARKET_OP_CHARGE
    MONTHLY_LEU, Market Operator Charge¬, *, *, MARKET_OP_CHARGE
];





Let RCount=NoOfRows('LIST');  
For i=0 to $(RCount) -1  

call RateAndConsumption( peek([Table Name],$(i)),peek([First Wild],$(i)),peek([Second Wild],$(i)),peek(Tag,$(i)))

Next i;

Thanks

Paul

Re: Loop through table values to input into a procedure

marcus_sommer — Thu, 06 Feb 2014 16:54:12 GMT

Outside from a load-statement peek() needed a table-name and field- and table-names should be in quotes:

peek(peek('Table Name',$(i), 'List')

- Marcus

Re: Re: Loop through table values to input into a procedure

paulm — Thu, 06 Feb 2014 17:12:00 GMT

Hi Marcus,

Thanks for the reply. Still struggling with this. I have changed it to input into a variable and still getting null. I assume I am doing something stupid?

Let RCount=NoOfRows('LIST'); 
For i=0 to $(RCount) -1 

let x =  peek(peek('Table Name',$(i), 'LIST'));

Next i;

Paul

Re: Loop through table values to input into a procedure

brindlogcool — Thu, 06 Feb 2014 17:37:09 GMT

Hi Paul,

Are you trying to use Peek within Peek.

I tried the code

let x = peek('Table_Name',$(i), 'LIST');

It works fine

Re: Re: Loop through table values to input into a procedure

paulm — Thu, 06 Feb 2014 17:38:55 GMT

HI,

Took out the double peal and that resolved it. Cheers for your help Markus.

Paul