topic Why Importing variables from excel using ForLoop and Peek doesnt work? in QlikView

Why Importing variables from excel using ForLoop and Peek doesnt work?

yanivvl0 — Wed, 16 Nov 2016 08:34:11 GMT

hi to all ,

i am trying to import values into variables like in the nice examole : https://community.qlik.com/thread/27883

i am using exactly the same code but no good ,

am i missisng something?

here is the good and the bad values for one variable :

see the attached files - it supose to be simple ,

thanks for your HELP ..

ElizaF — Wed, 16 Nov 2016 10:21:25 GMT

Hello,

The mistake is in how you define the variable [$(vVariable_Name)].

Pls change

Let [$(vVariable_Name2)] = Peek('vdb',vI2,'vServerName');

Let [$(vVariable_Name2)] = Peek('vServerName',vI2,'vServerName');

I hope to help you.

yanivvl0 — Wed, 16 Nov 2016 11:47:37 GMT

thanks Eliza !!

ElizaF — Wed, 16 Nov 2016 12:02:28 GMT

My pleasure .

Please mark , if it is correct the answers.