topic calculating cell value via load script in QlikView

topic calculating cell value via load script in QlikView https://community.qlik.com/t5/QlikView/calculating-cell-value-via-load-script/m-p/253105#M95954 <HTML><HEAD></HEAD><BODY><P> <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Hi,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Can someone help me with calculating cell value via load script.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Example data table</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border: currentColor; border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt;"><SPAN style="font-family: Times New Roman;"> </SPAN><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><SPAN style="font-family: Times New Roman;"> </SPAN><TD style="padding: 0cm 5.4pt; border: 1pt solid windowtext; width: 76.3pt; background-color: transparent; mso-border-alt: solid windowtext .5pt;" valign="top" width="102"><SPAN style="font-family: Times New Roman;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="mso-ansi-language: EN-US; font-family: Calibri;">Book</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; width: 42.5pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" valign="top" width="57"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Value</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TR><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TR style="mso-yfti-irow: 1;"><SPAN style="font-family: Times New Roman;"> </SPAN><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; width: 76.3pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="102"><SPAN style="font-family: Times New Roman;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="mso-ansi-language: EN-US; font-family: Calibri;">Sales</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 42.5pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="57"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">100</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TR><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TR style="mso-yfti-irow: 2;"><SPAN style="font-family: Times New Roman;"> </SPAN><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; width: 76.3pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="102"><SPAN style="font-family: Times New Roman;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="mso-ansi-language: EN-US; font-family: Calibri;">COGS</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 42.5pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="57"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">90</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TR><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TR style="mso-yfti-irow: 3; mso-yfti-lastrow: yes;"><SPAN style="font-family: Times New Roman;"> </SPAN><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; width: 76.3pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="102"><SPAN style="font-family: Times New Roman;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="mso-ansi-language: EN-US; font-family: Calibri;">Gross Margin</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 42.5pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="57"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TR><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Example Load script is:</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">DataRevenu:</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><STRONG style=": ; Courier New&quot: ; color: blue; font-size: 9pt; font-family: &quot;">LOAD</STRONG><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: maroon; font-family: &quot;Courier New&quot;; font-size: 9pt;">Book</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">, </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: maroon; font-family: &quot;Courier New&quot;; font-size: 9pt;">Value</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">FROM</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">[Revenue2011.xls]</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">(</SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">biff</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">, </SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">embedded</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">labels</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">, </SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">table</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">is</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> [DATA2011]); </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">How can I calculate GrossMargin via the load script?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Thanks,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Paul</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P></BODY></HTML> Mon, 17 Oct 2011 12:20:26 GMT 2011-10-17T12:20:26Z calculating cell value via load script https://community.qlik.com/t5/QlikView/calculating-cell-value-via-load-script/m-p/253105#M95954 <HTML><HEAD></HEAD><BODY><P> <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Hi,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Can someone help me with calculating cell value via load script.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Example data table</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border: currentColor; border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt;"><SPAN style="font-family: Times New Roman;"> </SPAN><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><SPAN style="font-family: Times New Roman;"> </SPAN><TD style="padding: 0cm 5.4pt; border: 1pt solid windowtext; width: 76.3pt; background-color: transparent; mso-border-alt: solid windowtext .5pt;" valign="top" width="102"><SPAN style="font-family: Times New Roman;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="mso-ansi-language: EN-US; font-family: Calibri;">Book</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; width: 42.5pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" valign="top" width="57"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Value</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TR><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TR style="mso-yfti-irow: 1;"><SPAN style="font-family: Times New Roman;"> </SPAN><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; width: 76.3pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="102"><SPAN style="font-family: Times New Roman;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="mso-ansi-language: EN-US; font-family: Calibri;">Sales</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 42.5pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="57"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">100</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TR><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TR style="mso-yfti-irow: 2;"><SPAN style="font-family: Times New Roman;"> </SPAN><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; width: 76.3pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="102"><SPAN style="font-family: Times New Roman;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="mso-ansi-language: EN-US; font-family: Calibri;">COGS</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 42.5pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="57"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">90</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TR><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TR style="mso-yfti-irow: 3; mso-yfti-lastrow: yes;"><SPAN style="font-family: Times New Roman;"> </SPAN><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; width: 76.3pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="102"><SPAN style="font-family: Times New Roman;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="mso-ansi-language: EN-US; font-family: Calibri;">Gross Margin</SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 42.5pt; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="57"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P></TD><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TR><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Example Load script is:</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">DataRevenu:</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><STRONG style=": ; Courier New&quot: ; color: blue; font-size: 9pt; font-family: &quot;">LOAD</STRONG><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: maroon; font-family: &quot;Courier New&quot;; font-size: 9pt;">Book</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">, </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: maroon; font-family: &quot;Courier New&quot;; font-size: 9pt;">Value</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">FROM</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">[Revenue2011.xls]</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">(</SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">biff</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">, </SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">embedded</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">labels</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;">, </SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">table</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> </SPAN><SPAN style="color: blue; font-family: &quot;Courier New&quot;; font-size: 9pt;">is</SPAN><SPAN style="color: black; font-family: &quot;Courier New&quot;; font-size: 9pt;"> [DATA2011]); </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">How can I calculate GrossMargin via the load script?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Thanks,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="color: #000000; font-size: 12pt; mso-ansi-language: EN-US; font-family: Calibri;">Paul</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P></BODY></HTML> Mon, 17 Oct 2011 12:20:26 GMT https://community.qlik.com/t5/QlikView/calculating-cell-value-via-load-script/m-p/253105#M95954 2011-10-17T12:20:26Z