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 Syntax

Is there any different between the following 2 formulas

1) sum({<Country = {'China','Canada'}>} Sales)

2) sum({$<Country = {'China','Canada'}>} Sales)

Thanks a lot!!

3 Replies
Not applicable
Author

Hi,

It is pretty much the same.  When the set modifier is omitted, $ is assumed.

Sean

neha_shirsath
Specialist
Specialist

Hi Herman,

The meaning of 2nd expression

2) sum({$<Country = {'China','Canada'}>} Sales)

Returns the sales for Country China & Canada including the current selection.

And in 1st expression

1) sum({<Country = {'China','Canada'}>} Sales)

is also same as second ,When the set to modify is omitted, $

is assumed.

Not applicable
Author

Thanks all.

Just wondering....I found that some of my set expressions were added a "$" automatically while some didn't. So, i was just pizzling what's going on... I normally didn't put "$" in my expressions.