topic Peek function not working in QlikView https://community.qlik.com/t5/QlikView/Peek-function-not-working/m-p/1303634#M406001 <HTML><HEAD></HEAD><BODY><P>Hi , I'm working on missing data generation for Exchange rate so I just have to take data with respect INR to USD conversion. But peek is not working properly. So dates are generated but exchange rate is not mapped for the same. Please have a look and revert ASAP.</P><P>Thanks in advance .</P></BODY></HTML> Fri, 30 Jun 2017 04:54:44 GMT Anonymous 2017-06-30T04:54:44Z Peek function not working https://community.qlik.com/t5/QlikView/Peek-function-not-working/m-p/1303634#M406001 <HTML><HEAD></HEAD><BODY><P>Hi , I'm working on missing data generation for Exchange rate so I just have to take data with respect INR to USD conversion. But peek is not working properly. So dates are generated but exchange rate is not mapped for the same. Please have a look and revert ASAP.</P><P>Thanks in advance .</P></BODY></HTML> Fri, 30 Jun 2017 04:54:44 GMT https://community.qlik.com/t5/QlikView/Peek-function-not-working/m-p/1303634#M406001 Anonymous 2017-06-30T04:54:44Z Re: Peek function not working https://community.qlik.com/t5/QlikView/Peek-function-not-working/m-p/1303635#M406002 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P><SPAN style="font-family: 'courier new', courier;">If(<SPAN style="color: #0000ff;">Len(Trim(Rate))=0</SPAN>,Peek(Rate),Rate) as Actual_Rate</SPAN></P><P>or,</P><P><SPAN style="font-family: 'courier new', courier;">If(<SPAN style="color: #0000ff; font-size: 13.3333px;">Len(Trim(Rate))=0</SPAN>,Peek(<SPAN style="color: #0000ff; font-size: 13.3333px;">Actual_Rate</SPAN>),Rate) as Actual_Rate</SPAN></P></BODY></HTML> Fri, 30 Jun 2017 05:15:41 GMT https://community.qlik.com/t5/QlikView/Peek-function-not-working/m-p/1303635#M406002 tresB 2017-06-30T05:15:41Z