topic Re: Set analysis $ and 1 diff in expression in QlikView

Set analysis $ and 1 diff in expression

ajaykumar1 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set analysis $ and 1 diff in expression

MindaugasBacius — Thu, 09 Jun 2016 06:51:05 GMT

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

Re: Set analysis $ and 1 diff in expression

PrashantSangle — Thu, 09 Jun 2016 06:51:22 GMT

Hi,

Yes both the expression work as per expected.

What are you trying to point out?

Regards

Re: Set analysis $ and 1 diff in expression

ajaykumar1 — Thu, 09 Jun 2016 06:57:57 GMT

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

Re: Set analysis $ and 1 diff in expression

Digvijay_Singh — Thu, 09 Jun 2016 07:04:25 GMT

'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.

Re: Set analysis $ and 1 diff in expression

PrashantSangle — Thu, 09 Jun 2016 07:04:36 GMT

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

Re: Set analysis $ and 1 diff in expression

ajaykumar1 — Thu, 09 Jun 2016 08:23:26 GMT

Thanks Max,

I got your point. Cleared.