topic Re: Syntax for “greater than or equal to” when defining a set? in QlikView

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

Thu, 03 Jul 2014 17:56:22 GMT

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

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

jerem1234 — Thu, 03 Jul 2014 18:02:12 GMT

Try this:

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

Hope this helps!

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

Thu, 03 Jul 2014 18:04:43 GMT

Hi Grace,

This should work

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

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

Thu, 03 Jul 2014 18:06:40 GMT

Success! Thanks for the help!