topic please some one help me with this Issue... in QlikView https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279977#M1203439 <HTML><HEAD></HEAD><BODY><P>Hi Shiva ,</P><P>Load this code</P><P>OverviewMeasureFormula:<BR />LOAD MeasureName as %MeasureName,<BR /> MeasureOverAvg co-pay,<BR /> MeasureOverMedian co-pay,<BR /> MeasureOvermode co-pay,<BR /> MeasureOverNRx,<BR /> MeasureOverNQTY,<BR /> MeasureOverTRx,<BR /> MeasureOverTQTY<BR />FROM<BR />CalculationsTable.xlsx<BR />(ooxml, embedded labels, table is Sheet1);<BR />OverviewMeasureFormula:<BR />LOAD MeasureName as %MeasureName,<BR /> MeasureOverAvg co-pay,<BR /> MeasureOverMedian co-pay,<BR /> MeasureOvermode co-pay,<BR /> MeasureOverNRx,<BR /> MeasureOverNQTY,<BR /> MeasureOverTRx,<BR /> MeasureOverTQTY<BR />FROM<BR />CalculationsTable.xlsx<BR />(ooxml, embedded labels, table is Sheet1);</P><P></P><P>Cheers ,</P><P>Bhushan N</P></BODY></HTML> Fri, 01 Oct 2010 08:24:31 GMT 2010-10-01T08:24:31Z please some one help me with this Issue... https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279971#M1203433 <HTML><HEAD></HEAD><BODY><P>I am trying to create table but I am getting Syntex Error can anyone please help me out from this Issue..</P><P></P><P>Syntax error, missing/misplaced FROM:<BR />OverviewMeasureFormula:<BR />LOAD MeasureName as %MeasureName,<BR /> MeasureOverAvg co-pay,<BR /> MeasureOverMedian co-pay,<BR /> MeasureOvermode co-pay,<BR /> MeasureOverNRx,<BR /> MeasureOverNQTY,<BR /> MeasureOverTRx,<BR /> MeasureOverTQTY,<BR />FROM<BR />CalculationsTable.xlsx<BR />(ooxml, embedded labels, table is Sheet1)<BR />OverviewMeasureFormula:<BR />LOAD MeasureName as %MeasureName,<BR /> MeasureOverAvg co-pay,<BR /> MeasureOverMedian co-pay,<BR /> MeasureOvermode co-pay,<BR /> MeasureOverNRx,<BR /> MeasureOverNQTY,<BR /> MeasureOverTRx,<BR /> MeasureOverTQTY,<BR />FROM<BR />CalculationsTable.xlsx<BR />(ooxml, embedded labels, table is Sheet1)</P><P></P><P></P><P></P></BODY></HTML> Thu, 30 Sep 2010 22:19:58 GMT https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279971#M1203433 2010-09-30T22:19:58Z please some one help me with this Issue... https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279972#M1203434 <HTML><HEAD></HEAD><BODY><P>hello</P><P>Erase the ' , ' before FROM</P><P>regards!</P></BODY></HTML> Thu, 30 Sep 2010 22:23:17 GMT https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279972#M1203434 2010-09-30T22:23:17Z please some one help me with this Issue... https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279973#M1203435 <HTML><HEAD></HEAD><BODY><P>also you are missing a ' ; ' at the end of the load statement</P></BODY></HTML> Thu, 30 Sep 2010 22:25:31 GMT https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279973#M1203435 2010-09-30T22:25:31Z please some one help me with this Issue... https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279974#M1203436 <HTML><HEAD></HEAD><BODY><P>I am trying to do as you told me beofre but I am getting this Problem agian..,how do I fix this error..,</P><P></P><P>Unknown statement<BR />OverviewMeasureFormula</P><P>LOAD<BR />MeasureName as %MeasureName,<BR /> MeasureOverAvg co-pay,<BR /> MeasureOverMedian co-pay,<BR /> MeasureOvermode co-pay,<BR /> MeasureOverNRx,<BR /> MeasureOverNQTY,<BR /> MeasureOverTRx,<BR /> MeasureOverTQTY<BR />FROM<BR />CalculationsTable.xlsx<BR />(ooxml, embedded labels, table is Sheet1)</P></BODY></HTML> Thu, 30 Sep 2010 22:43:02 GMT https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279974#M1203436 2010-09-30T22:43:02Z please some one help me with this Issue... https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279975#M1203437 <HTML><HEAD></HEAD><BODY><P>Hi, try this</P><P>OverviewMeasureFormula:<BR />LOAD MeasureName as %MeasureName,<BR /> [MeasureOverAvg co-pay],<BR /> [MeasureOverMedian co-pay],<BR /> [MeasureOvermode co-pay],<BR /> MeasureOverNRx,<BR /> MeasureOverNQTY,<BR /> MeasureOverTRx,<BR /> MeasureOverTQTY<BR />FROM<BR />CalculationsTable.xlsx<BR />(ooxml, embedded labels, table is Sheet1);</P></BODY></HTML> Thu, 30 Sep 2010 23:16:33 GMT https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279975#M1203437 2010-09-30T23:16:33Z please some one help me with this Issue... https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279976#M1203438 <HTML><HEAD></HEAD><BODY><P>Remove ',' From both load statement.</P></BODY></HTML> Fri, 01 Oct 2010 07:05:27 GMT https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279976#M1203438 suniljain 2010-10-01T07:05:27Z please some one help me with this Issue... https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279977#M1203439 <HTML><HEAD></HEAD><BODY><P>Hi Shiva ,</P><P>Load this code</P><P>OverviewMeasureFormula:<BR />LOAD MeasureName as %MeasureName,<BR /> MeasureOverAvg co-pay,<BR /> MeasureOverMedian co-pay,<BR /> MeasureOvermode co-pay,<BR /> MeasureOverNRx,<BR /> MeasureOverNQTY,<BR /> MeasureOverTRx,<BR /> MeasureOverTQTY<BR />FROM<BR />CalculationsTable.xlsx<BR />(ooxml, embedded labels, table is Sheet1);<BR />OverviewMeasureFormula:<BR />LOAD MeasureName as %MeasureName,<BR /> MeasureOverAvg co-pay,<BR /> MeasureOverMedian co-pay,<BR /> MeasureOvermode co-pay,<BR /> MeasureOverNRx,<BR /> MeasureOverNQTY,<BR /> MeasureOverTRx,<BR /> MeasureOverTQTY<BR />FROM<BR />CalculationsTable.xlsx<BR />(ooxml, embedded labels, table is Sheet1);</P><P></P><P>Cheers ,</P><P>Bhushan N</P></BODY></HTML> Fri, 01 Oct 2010 08:24:31 GMT https://community.qlik.com/t5/QlikView/please-some-one-help-me-with-this-Issue/m-p/279977#M1203439 2010-10-01T08:24:31Z