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: 
CVTWILLIAMSH4
Contributor
Contributor

set analysis greater than

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.

 

 

Labels (1)
2 Solutions

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

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

View solution in original post

hopkinsc
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

3 Replies
agigliotti
Partner - Champion
Partner - Champion

below should works:
Sum({<[APInv.InvoiceAmount]={">=5000"} >} )
hopkinsc
Partner - Specialist III
Partner - Specialist III

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

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.