topic Re: Set Analysis when using pick(match....... function in App Development

Set Analysis when using pick(match....... function

bc5891 — Sat, 16 Nov 2024 02:04:39 GMT

Hi,

I am creating a chart which should not be affected by a month year selection

like below:

When I use the following expression it works:

sum({$<[Month Year]= , PeriodDateNum={">=$(vPrior12MonthYearNum)"} >} [A] )

But when I try to introduce pick at the start of my expression, the same expression doesn;t work, it gets affected by the date selection.

PICK(MATCH(DIM, 'A', 'B'),

sum({$<[Month Year]= , PeriodDateNum={">=$(vPrior12MonthYearNum)"} >} [A] ) ,

sum({$<[Month Year]= , PeriodDateNum={">=$(vPrior12MonthYearNum)"} >} [B] )

)

Does anyone have a specific reason why this will not work or have a workaround? I need the dynamic nature of the pick and match function in my chart.

Thanks

Re: Set Analysis when using pick(match....... function

tresB — Tue, 23 Jun 2020 14:35:57 GMT

Try like:

PICK(MATCH( Only({1} DIM ), 'A', 'B'),

sum({$<[Month Year]= , PeriodDateNum={">=$(vPrior12MonthYearNum)"} >} [A] ) ,

sum({$<[Month Year]= , PeriodDateNum={">=$(vPrior12MonthYearNum)"} >} [B] )

)

Re: Set Analysis when using pick(match....... function

bc5891 — Tue, 23 Jun 2020 14:52:27 GMT

Thanks for the response - I did see something similar to this.

When I put the only ({1} field) addition, it does not work unfortunately - it actually shows no data then.

It's frustrating as the chart works perfectly without the pick(match function...but at the same time this is required!

Re: Set Analysis when using pick(match....... function

tresB — Tue, 23 Jun 2020 15:03:27 GMT

Could you share your app sample?

Re: Set Analysis when using pick(match....... function

bc5891 — Tue, 23 Jun 2020 15:12:44 GMT

Work policies don't enable me to do that.

some more details if it helps:

I am using an inline table as a data island.

- I have a calendar for monthyear

- The combo chart is using monthyear.

- The chart expression changes as per selection of the dimension in the data island.

- chart works if single set analysis expression and disregards monthyear

- chart does not work when using pick(match(....function using the data island, it filters down to single month.

There seems to be a similar thread on this which was unresolved as well...

Thanks

Re: Set Analysis when using pick(match....... function

jazzsran — Wed, 15 Sep 2021 05:20:11 GMT

I hope this is resolved as this is an old thread. Although for record, I am adding here some suggestions that worked for me.

1. Only({1}Dim) - works fine if you want to ignore selections.

2. When using pick-match statement, if you need to use expression as value, add it in a variable and use the variable instead; direct expressions doesn't work.

Eg: Pick(Match(Only({1}Dim, '1','2')),$(Variable1),$(Variable2))

Hope this helps.

Thanks,

Jaspreet

Re: Set Analysis when using pick(match....... function

tresB — Wed, 15 Sep 2021 05:34:39 GMT

Hi @jazzsran , thank you for sharing your solution. However, the statement :

When using pick-match statement, if you need to use expression as value, add it in a variable and use the variable instead; direct expressions doesn't work

might not be right. I would assume that the effect you saw could be because of the way you wrote your expression and/or variable definition. As general statement - this is probably mis-leading. I would like to ask you to share a sample qvf that demonstrates the issue and solution you have worked on.