topic Re: Script in QlikView https://community.qlik.com/t5/QlikView/Script/m-p/1281833#M401808 <HTML><HEAD></HEAD><BODY><P>Opened/[Expected Send] as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SentToOpenRate</SPAN>,</P><P></P><P>If [Expected Send] and be null or zero, you'll need an IF to work around that.</P></BODY></HTML> Wed, 15 Feb 2017 20:55:07 GMT m_woolf 2017-02-15T20:55:07Z Script https://community.qlik.com/t5/QlikView/Script/m-p/1281832#M401807 <HTML><HEAD></HEAD><BODY><P>I have two fields [Expected Send] and 'Opened'</P><P></P><P>I want to create a field called SentToOpenRate, by dividing 'Opened' by [Expected Send]</P><P></P><P>Can this be done in the script? If so, what is the proper structure?</P></BODY></HTML> Wed, 15 Feb 2017 20:51:45 GMT https://community.qlik.com/t5/QlikView/Script/m-p/1281832#M401807 evansabres 2017-02-15T20:51:45Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/1281833#M401808 <HTML><HEAD></HEAD><BODY><P>Opened/[Expected Send] as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SentToOpenRate</SPAN>,</P><P></P><P>If [Expected Send] and be null or zero, you'll need an IF to work around that.</P></BODY></HTML> Wed, 15 Feb 2017 20:55:07 GMT https://community.qlik.com/t5/QlikView/Script/m-p/1281833#M401808 m_woolf 2017-02-15T20:55:07Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/1281834#M401809 <HTML><HEAD></HEAD><BODY><P>May be this,</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[Expected Send] / <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Opened </SPAN>as Cal</SPAN></P></BODY></HTML> Wed, 15 Feb 2017 20:56:15 GMT https://community.qlik.com/t5/QlikView/Script/m-p/1281834#M401809 aarkay29 2017-02-15T20:56:15Z