set analysis greater than

[CVTWILLIAMSH4]

I am trying to filter an amount column to show invoices greater than 5000.

The code I am using is:

Sum({<[APInv.InvoiceAmount]={$(>=5000)}>} )

However, this does not seem to work for me.

[agigliotti · Accepted solution]

below should works:
Sum({<[APInv.InvoiceAmount]={">=5000"} >} )

[hopkinsc · Accepted solution]

You're missing quotes from the >=5000, try '>=5000'

[Brett_Bleess]

Since I was unsure myself whether the single or the double quotes were correct, I am putting a couple of links from Help in this one as well for anyone coming along in the future to verify themselves.

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunction...

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunction...

Cheers,
Brett