Last 7 days for the previous Year

[helen_pip]

Dear Qlikview user

I have the following expression, which give me the "OK" when in an expression builder, however when executed it has the following error message:

Error: Error in set modifier ad hoc element list: ',' or') expected

My expression is as follows:

=Count({$<FactDateNum={">=$(=AddYears(Today()-7,-1)<=$(=AddYears(Today()-1,-1)"}>}ID)

Any help or guidance would be greatly appreciated

Kind Regards

Helen

[sinanozdemir · Accepted solution]

Hi,

You are missing two parentheses

=Count({$<FactDateNum={">=$(=AddYears(Today()-7,-1))<=$(=AddYears(Today()-1,-1))"}>}ID)

Hope this helps.

[helen_pip]

Hello Sinan

Perfect! Thank you! I just saw so many brackets, I was unsure where the problem was

Thanks

Helen