topic Different values with the same dimension. in App Development

Different values with the same dimension.

Magogar — Thu, 02 Jun 2022 06:53:30 GMT

Hi, could anyone help me?
I want to show the unique clients that have operated by APP1 but not by APP2, and vice versa. I have managed to get it to work, but only if I filter by COD. (dimension). This happens because the nested set definition "P" ignores the COD dimension, it grabs all values. How should I formulate it, a solution would be without nesting, one set minus the other. How to solve it??

Correct data, but filtering by COD. = 321:

Incorrect data, without filtering

ONLY APP1: count({<TAPP={'12'},[fecha.autoCalendar.Year]={"$(=Year(max([fecha])))"}, cliente -= P({$<TAPP={'01','02','06','11'},[fecha.autoCalendar.Year]={"$(=Year(max([fecha])))"}>}cliente)>} distinct cliente)

ONLY APP2: count({$< TAPP={'01','02','06','11'},[fecha.autoCalendar.Year]={"$(=Year(max([fecha])))"}, cliente -= P({$<TAPP={'12'},[fecha.autoCalendar.Year]={"$(=Year(max([fecha])))"}>}cliente)>} distinct cliente)

Thanks!!

Re: Different values with the same dimension.

kaushiknsolanki — Wed, 01 Jun 2022 13:30:20 GMT

Hi @Magogar Can you share the expression you have used for all the measures.

Regards,

Kaushik Solanki

Re: Different values with the same dimension.

Magogar — Thu, 02 Jun 2022 06:58:01 GMT

Sorry. I forgot the most important part!

APP1: Sum({<TAPP={'12'},[fecha.autoCalendar.Year]={"$(=Year(max([fecha])))"}>}operaciones)

APP2: Sum({<TAPP={'01','02','06','11'},[fecha.autoCalendar.Year]={"$(=Year(max([fecha])))"}>}operaciones)

Thank you.