Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.