Set Analysis - second selection?

[#1]

Hi all,

I have following expression:

=-SUM( {1<TRANSYEAR={$(=Only(TRANSYEAR)-1)}>} $(varGrossSales))

It returns me the full set of records of variable Gross Sales, with the modifier selected year -1.

Now I want to take into consideration the country code. If I select the country, the result set should also be changed.

Is it possible to insert a new modifier: consider in the selection the year-1 and e.g.the country code.

I have tried this, but this does not work:

=-SUM( {1<TRANSYEAR={$(=Only(TRANSYEAR)-1)}>*countrycode} $(varGrossSales))

Thank you in advance.

Regards Christoph

[swuehl]

Have you tried something like

=-SUM( {1<TRANSYEAR={$(=Only(TRANSYEAR)-1)}, COUNTRYCODEFIELD = {$(=Only(COUNTRYCODEFIELD))} >} $(varGrossSales))

?

[#3]

Hi,

that is what I need in principle, but something is not working in this code.

Are you sure, it is possible with 2 selections?

Regards CH

[swuehl]

2 selections in one field (COUNTRYCODEFIELD)? Then only does not work.

Try

=-SUM( {1<TRANSYEAR={$(=Only(TRANSYEAR)-1)}, COUNTRYCODEFIELD = p() >} $(varGrossSales))

If this doesn't help you, could you upload a small sample file together with your expected outcome?

[gandalfgray]

If you just want to change the selection of TRANSYEAR with your set expression, and not affect other selections (ie in COUNTRYCODEFIELD, or any other field) why not use:

=-SUM( {$<TRANSYEAR={$(=Only(TRANSYEAR)-1)}>} $(varGrossSales))

That is change the starting '1' to '$'.

[#6]

Hi,

you have the yellow expression, this reacts to every filter selection. OK. This is the normal case without set analysis.

The grey expression is the set analysis, this should display only the full year of the selected transaction year.

And now it should also include the selection when filtering the country code.

Thank you in advance.

Regards CH

[#7]

Hi GandalfGrey,

thank you, but this is not useful for me, the setanalysis expression should give me only the full year. With the change to $, I will get the complete selection.

Regards CH

[gandalfgray]

Hi hasenclc,

I looked at your sample app.

The yellow expression is not without set expression, you have {$<TRANSYEAR={$(=Only(TRANSYEAR)-1)}>} there selecting previous year.

And as far as i can see it displays the full previous year (2010 if you selected 2011)

And when you select a country (DE for example), the yellow expression gives you the sales for 2010 for the selected country.

Isn't that what you want?

The grey expression does not follow your country selection since you have 1 before the set <>.

To me it looks like the yellow expr gives you what you want .

regards GG

[swuehl]

Would be helpful if you could add what you expect to see when doing selections in fields (specifying both the selections and the expected outcome).

If you are using the expression I suggested above

=-SUM( {1<TRANSYEAR={$(=Only(TRANSYEAR)-1)}, %COUNTRYID=p() >} $(varGrossSales))

then this should regard your selections in Country ID and TRANSYEAR (from the multi box), but if you select in any other field, like Day, Account or Division, this will not affect the outcome.

edit: Maybe you need to add the year restriction also to the p() function:

=-SUM( {1<TRANSYEAR={$(=Only(TRANSYEAR)-1)}, %COUNTRYID=p({<TRANSYEAR={$(=Only(TRANSYEAR)-1)}>}) >} $(varGrossSales))

[#10]

Hi GandalfGrey,

sometimes I am confused , I must admit, but not in this case.

Ok, the yellow expression has a set analysis, but for my point of view, the result is the same as without the set analysis. And this is not what I want.

Perhaps I have to explain a little bit better.

If you select a year, then I get a result for the yellow and the grey one. Great.

But my goal is, if I select for example a day, the grey one should remain the same, because it should display the full year (for comparison reasons)

Now I want to select a specific country. The grey one doesn't react, but for my goal, this should now.

I hope, you are not confused now.
Regards CH