topic Re: error in set modifier in QlikView

error in set modifier

samuel_brierley — Mon, 20 Jan 2014 16:06:08 GMT

Can someone explain where im going wrong?

=sum({$< [STSS Month] <= Month(Today())>} [Total Hours])

its supposed to add up total hours for those months that are = to the month of today

Re: error in set modifier

jerem1234 — Mon, 20 Jan 2014 16:10:18 GMT

Try this:

=sum({$<[STSS Month] = {$(=Month(Today()))}>} [Total Hours])

Hope this helps!

Re: error in set modifier

datanibbler — Mon, 20 Jan 2014 16:12:41 GMT

Hi samuel,

you have to put the second part of your set_expression in brackets if it is an expression,

like this:

>>> = sum({$<[STSS Month} <= {$(=Month(Today()))>} [Total Hours]) <<<

=> Further, that '<=' cannot be used just like that in a set_expression. The "main operator" always has to be an '='. You have to build in that '<=' as part of the expression.

HTH

Best regards,

DataNibbler

Re: error in set modifier

Nicole-Smith — Mon, 20 Jan 2014 16:15:30 GMT

=sum({$<[STSS Month] = {'<=$(=Month(Today()))'}>} [Total Hours])