Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
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);

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

Community Browser