Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

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

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

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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
Partner - Champion III
Partner - Champion III

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.