Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Statement Get's Error Message

Hello All, 

I am trying to diagnose a very simple load for a colleague and am getting invalid expression. Could somebody please help?

The invalid expression is coming from what is highlighted in red.

LOAD

[PO Status],
[Ariba REQ #],
[PO Number],
[PO Create Date],
[PO Val USD],
[PO Invoice Val USD],
[Item Val Remaining USD],
IF(SUM(DISTINCT[Item Val Remaining USD]/[PO Val USD]*100)>=10,'YES') AS PerctRemaining,
[PO Val Local Cur],
[PO Invoice Val Local Cur],
[Item Val Remaining Local Cur],
[PO Local Cur],
[PO Val Doc Cur],
[PO Invoice Val Doc Cur],
[Item Val Remaining Doc Cur],
[PO Document Cur],
Preparer,
Requester,
[PO Cost Center],
[Business Partner],
[Cc Owner],
[Vendor Number],
[Vendor Name],
[PO Line Item Number],
[PO Item Description],
[GL Account Number],
[GL Acct Long Description],
[Ariba Requisition Title],
[Comp Code],
Function,
[Aprimo Activity Id]
FROM
[C:\Users\reindem\Desktop\Open PO Report.xlsx]
(ooxml, embedded labels, header is 1 lines, table is AMER);

Thank you, 

Matt

3 Replies
Highlighted
Partner
Partner

Re: Statement Get's Error Message

Try replacing your red expression with the following:

IF(([Item Val Remaining USD]/[PO Val USD]*100)>=10,
'YES',
'NO') as PerctRemaining,
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Contributor II
Contributor II

Re: Statement Get's Error Message

Solved it. Thank you 

Highlighted
Specialist
Specialist

Re: Statement Get's Error Message

Mark as Solved please!

To help community find solutions, please don't forget to mark as correct.