Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Group By ? Invalid Expression Error

Hi All,

I am getting group by error ? how to resolve it...

MAin:

load

     MS_MAIN_ACNT_CODE,

  CUST_CODE1,

  OST_SUB_ACNT_CODE,

  OST_FC_ADJ_AMT,

  OST_FC_ORG_AMT,

  Sum(OST_FC_ORG_AMT-OST_FC_ADJ_AMT) as DebtorsOutStandingAmount,

  if(OST_DUE_DT<Today(),sum(OST_FC_ORG_AMT-OST_FC_ADJ_AMT)) as DebtorsOverdueAmount,

  CURR_CODE,

  OST_DOC_DT,

  OST_DUE_DT

Resident FT_OS

Group by CUST_CODE1;

DROP Table FT_OS;

10 Replies
Not applicable
Author

HI,

Debtors Outstanding Amount is Fine...

For Over Due Amount, I need to get Outstanding amount on from based on OST_DUE_DT Based on each & every transaction..