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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarjuna005
Contributor III
Contributor III

Set Analysis Expression "-=" operator not working in Qlik sense Version Nov 14.212.7 Patch2

Hello Team,

I am trying to fix the below set analysis expression "-=" operator not working.

In expression, I want to filter data related to Due amount as highlighted below 

 

Num(

  Sum({<

    Cleared_Flag={'Unpaid'},

     [%KeyDate]={"$(=max([%KeyDate]))"},

     IsDebitor={"$(vDebitorsOnly)"},

     [Ev_Overdue.Type]={'Overdue'},

     [Ev_Overdue.Bucket]-={'Due'}

    >}

  [Account_Receivable_Evolution.Amount_$(vCurrency)]

  ),

  '# ##0' & '$(vCurrencySymbol)'

)

This works earlier suddenly stopped working kindly help on this issue.

10 Replies
nagarjuna005
Contributor III
Contributor III
Author

Thanks for all your responses.

but looks like syntax error in condition so it works for me.

 

Num(

  Sum({<

    Cleared_Flag={'Unpaid'},

     [%KeyDate]={"$(=max([%KeyDate]))"},

     IsDebitor={"$(vDebitorsOnly)"},

     [Ev_Overdue.Type]={'Overdue'},

     [Ev_Overdue.Bucket]=-{'[Due]'}

    >}

  [Account_Receivable_Evolution.Amount_$(vCurrency)]

  ),

  '# ##0' & '$(vCurrencySymbol)'

)