topic Re: Year Field in QlikView

Year Field

Anonymous — Mon, 07 Oct 2013 16:44:07 GMT

I'm getting current year value from the script in a variable (vCYear). When I use this variable in Set Expression it works fine but when I try to do any subtractions like:

=sum({<FYear={$(vCYear-2)}>} Sales)

it does not work.

Re: Year Field

Clever_Anjos — Mon, 07 Oct 2013 16:45:13 GMT

=sum({<FYear={"$(=$(vCYear)-2)"}>} Sales)

Re: Year Field

v_iyyappan — Mon, 07 Oct 2013 16:47:24 GMT

Hi,

Try like this

=sum({<FYear={$(=vCYear)-2}>} Sales) or =sum({<FYear={'$(=vCYear)-2'}>} Sales)

regards,

Re: Year Field

Anonymous — Mon, 07 Oct 2013 17:16:16 GMT

Thank you both.

Both of the expressions that you guys mentioned worked:

=sum({<FYear={"$(=$(vCYear)-2)"}>} Sales)

and

=sum({<FYear={$(=vCYear)-2}>} Sales)