topic Peek Issue in QlikView

Peek Issue

Thu, 25 Aug 2011 18:27:21 GMT

Please check the attached example Peek file

Expecting Results

I would like to get the value in the Final table.

Advance thanks for your help.

Thu, 25 Aug 2011 18:55:04 GMT

hi, you don't make any relation between the tables, that's correct?

swuehl — Thu, 25 Aug 2011 18:58:37 GMT

Hope I got your issue correctly. Use this in the scrpt for final table:

Final:

Load * ,

if(IsNum(Ends)=0,peek(Newvalue),Ends) as Newvalue

resident A;