topic Re: SET MODIFIER 1 IN SET ANALYSIS in QlikView

SET MODIFIER 1 IN SET ANALYSIS

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

Hi,

Is it possible to apply the set modifier {1< in set analysis, only on a single group of the expressio? i.e, for the expression presented below, I need that the set modifier 1 shall acts only on the dimension ANNO, with the possibility of selecting subsets of other groups considered in the expression (COD_CAT, COD_PROD).

=sum({1<ANNO = {$(=max(ANNO)-1)}, COD_PROD= {'111'}, REGIME = {'1'},COD_CATEG = {'120200','120204','120206'}>}NUMBER)

Thanks

Davide

Re: SET MODIFIER 1 IN SET ANALYSIS

dominicmander — Tue, 20 Sep 2016 16:14:16 GMT

HI Davide,

You can use set analysis within the dollar expansion for ANNO, so ...

=sum({$<ANNO = {$(=max({1}ANNO)-1)}, COD_PROD= {'111'}, REGIME = {'1'},COD_CATEG = {'120200','120204','120206'}>}NUMBER)

... is that what you mean?

Re: SET MODIFIER 1 IN SET ANALYSIS

sunny_talwar — Tue, 20 Sep 2016 16:28:09 GMT

May be you are looking for this:

=Sum({<ANNO = {$(=Max(ANNO)-1)}, COD_PROD *= {'111'}, REGIME = {'1'}, COD_CATEG *= {'120200','120204','120206'}>} NUMBER)

If you don't want to see selection in ANNO to impact, then this:

=Sum({<ANNO = {$(=Max({1}ANNO)-1)}, COD_PROD *= {'111'}, REGIME = {'1'}, COD_CATEG *= {'120200','120204','120206'}>} NUMBER)

Re: SET MODIFIER 1 IN SET ANALYSIS

davdiste — Wed, 21 Sep 2016 08:00:47 GMT

Thx Dominc,

I've tried your solution and It doesn't work as I wish. Indeed if I select a month of the year , the result of the expression change (unlike my example above, where all the dimension of the expression are fixed).

I need the result to be fixed for the dimension ANNO and selectionable (modifiable) for the other dimension of the expression.

Thanks anyway.

Davide

Re: SET MODIFIER 1 IN SET ANALYSIS

davdiste — Wed, 21 Sep 2016 08:21:45 GMT

Sorry all!

I've found the solution I was looking for, and It it seems to work.

I more simple and doesn't require the set modifier {1<.

Probably was not the year (ANNO) the dimension that I should fix but the month (MESE).

=sum({$<ANNO = {$(=max(ANNO)-1)},MESE= {'*'}, COD_PROD= {'111'}, REGIME = {'1'},COD_CATEG = {'120200','120204','120206'}>} NUMBER)

Re: SET MODIFIER 1 IN SET ANALYSIS

davdiste — Wed, 21 Sep 2016 08:24:29 GMT

Thx Sunny,

The symbol * you put after the dimension (COD_PROD *) is an operator?

What it means?

Bye