Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MattReinders
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
Vegar
MVP
MVP

Try replacing your red expression with the following:

IF(([Item Val Remaining USD]/[PO Val USD]*100)>=10,
'YES',
'NO') as PerctRemaining,
MattReinders
Contributor II
Contributor II
Author

Solved it. Thank you 

Claudiu_Anghelescu
Specialist
Specialist

Mark as Solved please!

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