Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
andy70018
Partner - Contributor III
Partner - Contributor III

Ingoring multiple filters in set analysis

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

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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;

 

View solution in original post

4 Replies
Vegar
MVP
MVP

You could do something like this:

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

andy70018
Partner - Contributor III
Partner - Contributor III
Author

no, sorry - in this case also A is ignored

Vegar
MVP
MVP

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;

 

andy70018
Partner - Contributor III
Partner - Contributor III
Author

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