topic Can I access loaded fields in the script? in QlikView

Can I access loaded fields in the script?

Thu, 11 Oct 2012 09:02:55 GMT

Hi everyone!

I don´t know if can be done. I need to acces to the loaded values of some fields to create a new table inline in the script.

Is it possible???

Thanks a lot.

Re: Can I access loaded fields in the script?

Miguel_Angel_Baeyens — Thu, 11 Oct 2012 09:06:56 GMT

Hi,

You have both Peek() and Lookup(), and likely FieldValue() to achieve that. What do you exactly want to do?

Miguel

Re: Can I access loaded fields in the script?

Thu, 11 Oct 2012 09:12:33 GMT

Thanks for the reply.

Well, I´ve got an excel table whith a lot of clients and 12 columns, one per month. If the client answered in Jan, the the register ID - Column1 has a '1', and null in the othe case. If he answered en february the the 1 is in the register ID - Column2. I want to create a table that combine the 12 columns in one column. ID Month. If the client is from Jan, then in month will apear a 1, etc.

I hope that i explained myself.