topic Re: Set Analysis Criteria to move with selection in App Development

Set Analysis Criteria to move with selection

pauldamen — Tue, 20 Mar 2018 09:12:52 GMT

Hi,

I have quite a simple question but can't seem to figure it out.

I have the following formula:

sum({< ProductName = {'CBL*'}>}BALANCE_QTY)

Because I only want to look at products starting with CBL, BUT if I select 1 product with CBL i still want it to move with the selection of that product. Writing the set analysis like this will always show the total of all products starting with CBL.

Hope you can provide me with an answer how to fix this.

Regards, Paul

Re: Set Analysis Criteria to move with selection

YoussefBelloum — Tue, 20 Mar 2018 09:29:23 GMT

Hi,

you can try this:

=if(GetSelectedCount(ProductName)=0,

sum({< ProductName = {'CBL*'}>}BALANCE_QTY),

sum(BALANCE_QTY)

)

Re: Set Analysis Criteria to move with selection

pauldamen — Tue, 20 Mar 2018 09:31:32 GMT

Thanks, didn't think about this work around

Re: Set Analysis Criteria to move with selection

YoussefBelloum — Tue, 20 Mar 2018 09:41:14 GMT

I'm sure there is other solutions for this, in the meantime you can use it

good luck

Re: Set Analysis Criteria to move with selection

sunny_talwar — Tue, 20 Mar 2018 11:24:17 GMT

How about this?

Sum({<ProductName *= {'CBL*'}>} BALANCE_QTY)

Re: Set Analysis Criteria to move with selection

YoussefBelloum — Tue, 20 Mar 2018 12:48:55 GMT

Hi stalwar1‌, this will work when there is no selection on the product and also when there is one product selected ?

Re: Set Analysis Criteria to move with selection

sunny_talwar — Tue, 20 Mar 2018 12:51:12 GMT

I was not 100% sure what Paul wanted, but this is what it will do

ProductName

CBL xyz

CBL abc

CBL ddd

JBL xyz

JBL abc

JBL ddd

When nothing is selected... the expression will show this

CBL xyz

CBL abc

CBL ddd

When CBL abc is selected.... the expression should show

CBL abc

When JBL abc is selected ... the expression will show nothing

Updated my post with images and sample

Re: Set Analysis Criteria to move with selection

YoussefBelloum — Tue, 20 Mar 2018 12:54:47 GMT

it is replacing what I wrote above

Re: Set Analysis Criteria to move with selection

sunny_talwar — Tue, 20 Mar 2018 12:57:18 GMT

Your's is slightly different... if you select JBL abc... you will see JBL abc with your expression

For the other two cases... it will work the same way

But again, I don't know the requirement and your solution may very well be what is needed here

Re: Set Analysis Criteria to move with selection

YoussefBelloum — Tue, 20 Mar 2018 13:03:37 GMT

sorrry, it is the fast food effect, I need a coffee ..

Re: Set Analysis Criteria to move with selection

sunny_talwar — Tue, 20 Mar 2018 13:04:31 GMT

let's go together... I am in need of a coffee also

Re: Set Analysis Criteria to move with selection

YoussefBelloum — Tue, 20 Mar 2018 13:07:12 GMT

I would really like..........