topic Re: Ingoring multiple filters in set analysis in App Development

Ingoring multiple filters in set analysis

andreas_schoedlbauer — Sat, 16 Nov 2024 02:33:05 GMT

Hi all

assume you have 10 filters (A, B, C ...) on a dashboard and a KPI that should apply only the first filter (A). All other filters have to be ignored in the calculation. Is there any syntax in set analysis to say "take only this filter ... an ignore all others"?

Thanks a lot

Re: Ingoring multiple filters in set analysis

Vegar — Wed, 29 Apr 2020 18:22:13 GMT

You could do something like this:

=sum({1<[A]= P([A])>}Amount)

Re: Ingoring multiple filters in set analysis

andreas_schoedlbauer — Wed, 29 Apr 2020 18:33:59 GMT

no, sorry - in this case also A is ignored

Re: Ingoring multiple filters in set analysis

Vegar — Wed, 29 Apr 2020 21:10:59 GMT

It should not ignore A.

=sum({1<[A]= P([A])>}Amount)

Try using the expression on this datamodel.

Transactions: Load TransLineID, TransID, Pick(Ceil(3*Rand1),'A','B','C') as D, Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as C, Pick(Ceil(3*Rand()),'X','Y','Z') as B, mod(TransID,26)+1 as A, Round(1000*Rand()*Rand()*Rand1) as Amount; Load Rand() as Rand1, IterNo() as TransLineID, RecNo() as TransID Autogenerate 1000 While Rand()<=0.5 or IterNo()=1;

Re: Ingoring multiple filters in set analysis

andreas_schoedlbauer — Thu, 30 Apr 2020 06:52:31 GMT

you are right, I also tried it with another simple model and it works as you describe.

I will check, why it does not work in the other modell, but thanks a lot for your help.

Kind regards, Andy