Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Sum({$<[Gift or Payment Flag] ={'Payment'}, [Pledge Year] = {'>=2007'} >} [Payment Amount])
Hope this helps!
Try this:
=Sum({$<[Gift or Payment Flag] ={'Payment'}, [Pledge Year] = {'>=2007'} >} [Payment Amount])
Hope this helps!
Hi Grace,
This should work
=Sum({$<[Gift or Payment Flag] ={'Payment'}, [Pledge Year] = {">=2007"} >} [Payment Amount])
Success! Thanks for the help!