Set analysis $ and 1 diff in expression

[ajaykumar1]

Hi All,

I have some doubt.

As per QV 11 manual;

Sum({$<[Carrier's Operating Region] = {'Domestic', 'Latin

America'}, Year = {2010}>} [# Departures Performed])

This will use a record set based on the current selections where the

Carrier's Operating Region field is either Domestic or Latin America,

and only those records corresponding to the year 2010.

Notice how two elements in the field value definition have been separated

by a comma.

• Sum({1<[Carrier's Operating Region] = {'Domestic', 'Latin

America'}, Year = {2011}>} [# Departures Performed])

In this expression, the only difference from the preceding example is the

use of the number 1 as the set identifier. The calculation will use the entire

document record set as a starting point, disregarding all user selections,

but take into account only those records where the Carrier's Operating

Region is either Domestic or Latin America, and will only look at those

records corresponding to the year 2011.

What will be the difference between my attached image 1 and image 2.

More thanks,

Ajay

[MindaugasBacius]

While choosing from the Dept list only Sales or Marketing you should get the difference.

[PrashantSangle]

Hi,

Yes both the expression work as per expected.

What are you trying to point out?

Regards

[ajaykumar1]

Hi Max,

What i understood from the 11 manual; if we use 1 in expression it will give all the data in expression irrespective of selection.

If $ it gives the values based on selection.

Correct me if am wrong.

That difference i want to know.

Thanks,

Ajay

[Digvijay_Singh]

'1' means it would ignore your (other) selections but it will respect your filtered mentioned in set analysis. I think you should get the difference once you select only sales or only marketing or only manufact. See what happens after that.

[PrashantSangle · Accepted solution]

Hi,

Yes 1 will give all the data in expression irrespective of selection but in your set analysis you have mention department.

Therefore it returns data for those department only.

I hope you got point.

Regards

[ajaykumar1]

Thanks Max,

I got your point. Cleared.