topic Re: Make set analysis immune to all but one selection in App Development

Make set analysis immune to all but one selection

daviddiener — Mon, 20 Dec 2021 21:08:46 GMT

Hi, I have the following Set Analysis on a bar chart:

=count({1<
SDTL_AUSPACKDATUM={">=$(v_Datum2YearsAgo) <=$(v_DatumToday)"}
>}Distinct SDTL_REFERENZ_NR)

I included "1" to make the chart immune against all selections. Now i want to make an exception for 1 specific selection, so the charts is affected by it's selection. How could i do this?

Thanks in advance 🙂

Re: Make set analysis immune to all but one selection

Vegar — Wed, 07 Oct 2020 12:11:59 GMT

Maybe like this: (Assuming you want selections in the YourDimesion field to affect the chart.)

count({1<
SDTL_AUSPACKDATUM={">=$(v_Datum2YearsAgo) <=$(v_DatumToday)"},
YourDimension = P(YourDimension)
>}Distinct SDTL_REFERENZ_NR)

Re: Make set analysis immune to all but one selection

sunny_talwar — Wed, 07 Oct 2020 12:47:01 GMT

@daviddienerIn addition to what @Vegar, you can also try this if it has to be direct selection in the specific field you want to have selection in

=Count({1<SDTL_AUSPACKDATUM = {">=$(v_Datum2YearsAgo)<=$(v_DatumToday)"}, yourDimension = $::yourDimension>} DISTINCT SDTL_REFERENZ_NR)

$::yourDimension will make sure that only direct selection in the field impacts the chart, whereas p(yourDimension) will change if another selection impacts the possible value in yourDimension. May be that is what you want, but I just wanted to list the other option just in case you need that.