topic Re: Re: set analysis syntax error in QlikView

set analysis syntax error

Wed, 08 Oct 2014 11:14:39 GMT

Can someone please tell me whats wrong with these two syntaxes

sum({<Year = ">= ($(CurrrentYear) - 2)">})

sum({<Year = ">= $(CurrrentYear) - 2">})

sum({<Year = " ($(CurrrentYear) - 2)">})

Shah

Re: set analysis syntax error

Gysbert_Wassenaar — Wed, 08 Oct 2014 11:18:35 GMT

The part on the right side of the = sign needs to be enclosed in curly braces too:

sum({<Year = {">= $(CurrrentYear) - 2"} >})

Re: set analysis syntax error

sivarajs — Wed, 08 Oct 2014 11:21:09 GMT

Sum({<Year = {">= $(CurrrentYear - 2)"}>})

Re: Re: set analysis syntax error

Wed, 08 Oct 2014 13:34:22 GMT

still not working. I have confirmed that there is data for 2013 and 2014 and variable CurrrentYear value is 2014. I am doing some mistake in the syntamx

sum({<Year = {">= $(CurrrentYear) - 2"} >} revenue)

Shah

Re: set analysis syntax error

anbu1984 — Wed, 08 Oct 2014 13:39:39 GMT

Can you attach sample qvw

Re: set analysis syntax error

rubenmarin — Wed, 08 Oct 2014 13:41:21 GMT

Hi Syed, you can try:

sum({<Year = {">= $(=CurrrentYear-2)"}>} revenue)

Check if 'currrent' (with 3 'r') is correct.

Re: Re: set analysis syntax error

Gysbert_Wassenaar — Wed, 08 Oct 2014 13:46:45 GMT

Make sure to use the exact case sensitive field names.

Check that the expression works if you hard code the year:

sum({<Year = {">=2014"} >} revenue)