topic Set Analysis in QlikView

Set Analysis

Mon, 26 Mar 2012 04:11:38 GMT

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

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

CELAMBARASAN — Mon, 26 Mar 2012 04:30:28 GMT

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 — Mon, 26 Mar 2012 04:55:49 GMT

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)

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

Hope this helps you.

Regards,

Jagan.