Syntax for “greater than or equal to” when defining a set?

[#1]

Hi everyone,

I’m new to Qlik and working on a report for which I need to limit a chart to only display information regarding pledges in or after 2007.  I’m able to limit to just pledges in 2007 using this:

=Sum({$<[Gift or Payment Flag] ={'Payment'}, [Pledge Year] = {'2007'} >}  [Payment Amount])

But I get an error is I use this:

=Sum({$<[Gift or Payment Flag] ={'Payment'}, [Pledge Year] >= {'2007'} >}  [Payment Amount])

What is the correct syntax for “greater than or equal to” when defining a set?

Thanks!

Grace

[jerem1234 · Accepted solution]

Try this:

=Sum({$<[Gift or Payment Flag] ={'Payment'}, [Pledge Year] = {'>=2007'} >}  [Payment Amount])

Hope this helps!

[#3]

Hi Grace,

This should work

=Sum({$<[Gift or Payment Flag] ={'Payment'}, [Pledge Year] = {">=2007"} >}  [Payment Amount])

[#4]

Success!  Thanks for the help!