topic Re: set analysis greater than in QlikView

set analysis greater than

CVTWILLIAMSH4 — Sat, 16 Nov 2024 03:16:22 GMT

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.

Re: set analysis greater than

agigliotti — Tue, 18 Jun 2019 08:23:21 GMT

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

Re: set analysis greater than

hopkinsc — Tue, 18 Jun 2019 08:55:08 GMT

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

Re: set analysis greater than

Brett_Bleess — Wed, 17 Jul 2019 18:37:17 GMT

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/ChartFunctions/SetAnalysis/set-modifiers.htm

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Cheers,
Brett