topic Re: Set analysis issue in App Development

Set analysis issue

peterstalberg — Tue, 14 Feb 2023 08:10:36 GMT

Hi experts,

I'm stuck in a set analysis expression not giving me the expected result. Check out the table below, country Sweden and customer 'BB' & 'CC' are selected. Measures in column 3-5 gives me the expected result. For column 6 I want to show all sum(Sales) except for customers NOT selected under the selected country ('AA' & 'DD'). Any help on how to phrase this set expression would be highly appreciated. RGDS//Peter

Re: Set analysis issue

tresB — Tue, 14 Feb 2023 08:57:35 GMT

Your first three measures look to be equivalent to simple - Sum(Sales). While for the last one, you could try like:

Sum({1<Customer=e(Customer)>}Sales)

Re: Set analysis issue

peterstalberg — Tue, 14 Feb 2023 16:34:23 GMT

Hi Tresesco,

Thank you very much for your response. Unfortunately, this expression excludes customer 'BB' & 'CC'. AS described previously, I want to exclude 'AA' & 'DD' which has not be selected under Sweden an then include everything else. I have attached the qvf for clarity. Appreciate any further input. Regards//Peter

Note: Sweden, 'BB' & 'CC' are selected in the table.

Re: Set analysis issue

tresB — Wed, 15 Feb 2023 05:22:35 GMT

Well, if you are looking for something like below:

Sum({1<Customer=e({<Customer,Country=$::Country>}Customer)>+<Customer=p(Customer)>}Sales)

Possibly the expression can be simplified, you can give a try.

Re: Set analysis issue

peterstalberg — Wed, 15 Feb 2023 07:52:59 GMT

Hi Tresesco,

Spot on - thank you very much😀 Not sure if I can simplify your suggestion but I'll try to change the other measures using e & p switches rather than the "getfieldselections" approach. RGDS//Peter