topic Re: how to get field in QlikView https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20712#M788357 <HTML><HEAD></HEAD><BODY><P>You want these two expressions in the chart or in Load script? Or you are trying to do a nested if? </P></BODY></HTML> Wed, 14 Feb 2018 01:45:03 GMT vishsaggi 2018-02-14T01:45:03Z how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20706#M788351 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P>i have concern regarding this below i don't know how o do this.</P><P></P><P>=IF([Field1]='SUP' get this field [Field3])</P><P>=IF([Field4]='MGR' get this field [Field4])</P><P></P><P></P><P>Best Regards,</P><P>Bing</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20706#M788351 bsbernabe 2020-11-25T16:16:04Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20707#M788352 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=IF([Field1]='SUP', [Field3]) as fieldname</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=IF([Field4]='MGR', [Field4]) as fieldname2</P></BODY></HTML> Wed, 14 Feb 2018 00:43:05 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20707#M788352 Anil_Babu_Samineni 2018-02-14T00:43:05Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20708#M788353 <HTML><HEAD></HEAD><BODY><P>Thanks Anil,</P><P>Not possible that, what i want for this is that IF([Field1]='SUP' i want to get the value of this [Field3]), but any way thank you</P></BODY></HTML> Wed, 14 Feb 2018 01:00:38 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20708#M788353 bsbernabe 2018-02-14T01:00:38Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20709#M788354 <HTML><HEAD></HEAD><BODY><P>What i provide willfor deserve the same. Are you still facung thw issue after using the constant. Will uu provide image</P></BODY></HTML> Wed, 14 Feb 2018 01:02:52 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20709#M788354 Anil_Babu_Samineni 2018-02-14T01:02:52Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20710#M788355 <HTML><HEAD></HEAD><BODY><P>Can you share the exact need, In normal scenario in the qlik script one row of source data is processed together and creates one record in Qlik table, so what if one record as Field1 ='SUP' and next record doesn't, but Field3 will be&nbsp; created by any means once it is defined in the script in the load statement.</P></BODY></HTML> Wed, 14 Feb 2018 01:13:42 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20710#M788355 Digvijay_Singh 2018-02-14T01:13:42Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20711#M788356 <HTML><HEAD></HEAD><BODY><P>You can&nbsp; drop the field later after the load using DROP statement by checking if Field3 has any value loaded.</P></BODY></HTML> Wed, 14 Feb 2018 01:15:54 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20711#M788356 Digvijay_Singh 2018-02-14T01:15:54Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20712#M788357 <HTML><HEAD></HEAD><BODY><P>You want these two expressions in the chart or in Load script? Or you are trying to do a nested if? </P></BODY></HTML> Wed, 14 Feb 2018 01:45:03 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20712#M788357 vishsaggi 2018-02-14T01:45:03Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20713#M788358 <HTML><HEAD></HEAD><BODY><P>In a load script, something like:</P><P></P><P>...</P><P><EM>If(Field1 = 'SUP', Field3, If(Field4 = 'MGR', Field4)) as Result,</EM></P><P><EM>...</EM></P></BODY></HTML> Wed, 14 Feb 2018 06:17:58 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20713#M788358 jonathandienst 2018-02-14T06:17:58Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20714#M788359 <HTML><HEAD></HEAD><BODY><P>Thank you so much for all of you guys i already fixed this concern </P></BODY></HTML> Wed, 14 Feb 2018 08:04:09 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20714#M788359 bsbernabe 2018-02-14T08:04:09Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20715#M788360 <HTML><HEAD></HEAD><BODY><P>Can you close the thread marking helpful responses and post your solution how you fixed so that other developers can know when they come across this thread. </P></BODY></HTML> Wed, 14 Feb 2018 16:49:46 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20715#M788360 vishsaggi 2018-02-14T16:49:46Z Re: how to get field https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20716#M788361 <HTML><HEAD></HEAD><BODY><P>Could you share your solution and mark this thread as 'Resolved' after that?</P></BODY></HTML> Wed, 14 Feb 2018 19:09:42 GMT https://community.qlik.com/t5/QlikView/how-to-get-field/m-p/20716#M788361 qlikwiz123 2018-02-14T19:09:42Z