Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

please some one help me with this Issue...

I am trying to create table but I am getting Syntex Error can anyone please help me out from this Issue..

Syntax error, missing/misplaced FROM:
OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY,
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1)
OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY,
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1)

6 Replies
Not applicable

please some one help me with this Issue...

hello

Erase the ' , ' before FROM

regards!

Not applicable

please some one help me with this Issue...

also you are missing a ' ; ' at the end of the load statement

Not applicable

please some one help me with this Issue...

I am trying to do as you told me beofre but I am getting this Problem agian..,how do I fix this error..,

Unknown statement
OverviewMeasureFormula

LOAD
MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1)

Not applicable

please some one help me with this Issue...

Hi, try this

OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
[MeasureOverAvg co-pay],
[MeasureOverMedian co-pay],
[MeasureOvermode co-pay],
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1);

Highlighted
suniljain
Honored Contributor

please some one help me with this Issue...

Remove ',' From both load statement.

Not applicable

please some one help me with this Issue...

Hi Shiva ,

Load this code

OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1);
OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1);

Cheers ,

Bhushan N