https://community.qlik.com/t5/QlikView/Dynamic-Values-in-Script/m-p/1794843#M1211081 <P>Hi all,</P><P>Need help for one of my requirement.</P><P>Lets say I have an excel which has values,</P><P>Product, KPI Name, Target days</P><P>P1,K1,15</P><P>P1,K2,15</P><P>P2,K1,25</P><P>P2,K2,25.</P><P>These are the values in excel. I have loaded these values.&nbsp;</P><P>In the existing tables, I have dateassigned column.&nbsp;</P><P><STRONG>Logic required:</STRONG></P><P>All these days For Target date used the below logic&nbsp;</P><P>LastWorkDate(DATEASSIGNED,15) AS Target_date.</P><P>&nbsp;</P><P>But now I need to get this 15 value dynamically. i.e.,Target days column from loaded excel Based on Product and KPI name.</P><P>Help me in implementing this.</P><P>&nbsp;</P> Fri, 26 Mar 2021 13:50:10 GMT thanmaya07 2021-03-26T13:50:10Z https://community.qlik.com/t5/QlikView/Dynamic-Values-in-Script/m-p/1794843#M1211081 <P>Hi all,</P><P>Need help for one of my requirement.</P><P>Lets say I have an excel which has values,</P><P>Product, KPI Name, Target days</P><P>P1,K1,15</P><P>P1,K2,15</P><P>P2,K1,25</P><P>P2,K2,25.</P><P>These are the values in excel. I have loaded these values.&nbsp;</P><P>In the existing tables, I have dateassigned column.&nbsp;</P><P><STRONG>Logic required:</STRONG></P><P>All these days For Target date used the below logic&nbsp;</P><P>LastWorkDate(DATEASSIGNED,15) AS Target_date.</P><P>&nbsp;</P><P>But now I need to get this 15 value dynamically. i.e.,Target days column from loaded excel Based on Product and KPI name.</P><P>Help me in implementing this.</P><P>&nbsp;</P> Fri, 26 Mar 2021 13:50:10 GMT https://community.qlik.com/t5/QlikView/Dynamic-Values-in-Script/m-p/1794843#M1211081 thanmaya07 2021-03-26T13:50:10Z