Set Analysis

[#1]

Sum({$<Year = {2005 },Month = {jan,Feb }>} Sales)

Is the above expression is a valid expression ???????????????

[CELAMBARASAN]

Hi,

     There is no problem for numbers.

     For literals you have to use single quotes

Check with it.

Sum({$<Year = {2005},Month = {'Jan','Feb'}>} Sales)

Celambarasan

[jagan]

Hi,

It is not mandatory to use Single quotes for strings in set analysis expressions.  But it is good practice to use Single quotes.

=Sum({$<Year = {2005 },Month = {'Jan','Feb' }>} Sales)

Note : Also qlikview is case sensitive, you used jan, Feb in two different casings, I think it should be Jan, Feb.  Your expression should be

=Sum({$<Year = {2005 },Month = {'Jan','Feb' }>} Sales)

or

=Sum({$<Year = {2005 },Month = {Jan,Feb}>} Sales)

Hope this helps you.

Regards,

Jagan.