Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sum({$<Year = {2005 },Month = {jan,Feb }>} Sales)
Is the above expression is a valid expression ???????????????
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
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.