topic Re: Set Analysis Syntax in QlikView

Set Analysis Syntax

Fri, 11 Jan 2013 04:51:52 GMT

Is there any different between the following 2 formulas

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

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

Thanks a lot!!

Re: Set Analysis Syntax

Fri, 11 Jan 2013 05:12:20 GMT

Hi,

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

Sean

Re: Set Analysis Syntax

neha_shirsath — Fri, 11 Jan 2013 05:19:11 GMT

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.

Re: Set Analysis Syntax

Fri, 11 Jan 2013 06:12:40 GMT

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.