Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
no, sorry - in this case also A is ignored
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;
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