topic How to take a string value as a variable using peek or another function? in QlikView https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165413#M37725 <HTML><HEAD></HEAD><BODY><P></P><PRE class="jive_text_macro jive_macro_quote" jivemacro="quote"><BR />ivan_will wrote:But I have to take the text from a table !</PRE><BR /><BR /> <P>Yes, understood. I generated a table. I took the text from it. What do you want me to use if not an autogenerated table? Would you be more convinced by an inline load? More rows in the table? It doesn't matter. It still works.</P></BODY></HTML> Wed, 16 Mar 2011 23:09:29 GMT johnw 2011-03-16T23:09:29Z How to take a string value as a variable using peek or another function? https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165408#M37720 <HTML><HEAD></HEAD><BODY><P></P><P>Hi, I need to take a value from a filed in a table - The field has only one value. But when use peek with string value/filed it doesn't work !!! When the filed RRR is a number it works .... So how to take RRR as a variable (neede_value)?</P><P></P><P>check:</P><P>load</P><P>'dfl;ids aofd apiajovdskmdsf wp'oqr0932904w-93q e-0ewriufd' as RRR</P><P>resident main_check;</P><P></P><P>let needed_value = peek ( 'RRR' , 0 , 'check') ;</P><P></P><BR /><BR /></BODY></HTML> Wed, 16 Mar 2011 22:13:19 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165408#M37720 ivan_will 2011-03-16T22:13:19Z How to take a string value as a variable using peek or another function? https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165409#M37721 <HTML><HEAD></HEAD><BODY><P>Peek() works equally well with strings and numbers... In your example, you have a single quote in the middle of your string. I think your load statement should fail even before the peek() function...</P></BODY></HTML> Wed, 16 Mar 2011 22:41:49 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165409#M37721 Oleg_Troyansky 2011-03-16T22:41:49Z How to take a string value as a variable using peek or another function? https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165410#M37722 <HTML><HEAD></HEAD><BODY><P>OK , I have replaced the quote and the spaces and even doesn't work !!! Any solution ... ?</P></BODY></HTML> Wed, 16 Mar 2011 22:48:29 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165410#M37722 ivan_will 2011-03-16T22:48:29Z How to take a string value as a variable using peek or another function? https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165411#M37723 <HTML><HEAD></HEAD><BODY><P>Working example attached. Script below.</P><P style="padding-left:30px;">LOAD 'Test String' as String AUTOGENERATE 1;<BR />LET Variable = peek('String');</P></BODY></HTML> Wed, 16 Mar 2011 22:55:23 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165411#M37723 johnw 2011-03-16T22:55:23Z How to take a string value as a variable using peek or another function? https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165412#M37724 <HTML><HEAD></HEAD><BODY><P>Thanks,</P><P>But I have to take the text from a table !</P><P>Can't manage how to do it...</P></BODY></HTML> Wed, 16 Mar 2011 23:03:02 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165412#M37724 ivan_will 2011-03-16T23:03:02Z How to take a string value as a variable using peek or another function? https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165413#M37725 <HTML><HEAD></HEAD><BODY><P></P><PRE class="jive_text_macro jive_macro_quote" jivemacro="quote"><BR />ivan_will wrote:But I have to take the text from a table !</PRE><BR /><BR /> <P>Yes, understood. I generated a table. I took the text from it. What do you want me to use if not an autogenerated table? Would you be more convinced by an inline load? More rows in the table? It doesn't matter. It still works.</P></BODY></HTML> Wed, 16 Mar 2011 23:09:29 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165413#M37725 johnw 2011-03-16T23:09:29Z How to take a string value as a variable using peek or another function? https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165414#M37726 <HTML><HEAD></HEAD><BODY><P>Just using FieldValue('field',number of position in the fiield)</P><P></P><P><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 18 Mar 2011 05:41:42 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-string-value-as-a-variable-using-peek-or-another/m-p/165414#M37726 ivan_will 2011-03-18T05:41:42Z