Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
robertsb41
Contributor III
Contributor III

Calculate an Expression off of Available Selections

I have some filters Company & Contract ID.  When I select a Company it gives me a list of corresponding Contract ID's and grays out the rest.  I want to create a KPI expression that uses the data in the available Contract ID's (not the grayed ones). It currently only uses the data that relates to the selected company.

 

Is that possible?

Thank you!

Labels (1)
2 Replies
Anismohamed32
Partner - Contributor III
Partner - Contributor III

Can you able to explain it better with screenshots or sample app with dummy data
robertsb41
Contributor III
Contributor III
Author

When I select a company it gives my the available contract id's as you can see in the pic.  My expression works when I select the available contract Id's by themselves and remove the company selection.  But I want to make the company selection and have my expression just use the available contract id's.

sum({<[Amount]={"=[Bid Rank] = 2"}>} Amount) - sum(aggr(if(([Bid Rank] = 2),[Direct_Cost_$]),[Amount]))

robertsb41_0-1594838700952.png