Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

P() in a set expression on both side of the = sign

I am trying to write a formula using set expressoins that says all selected items in DA and location, at the moment I get the P() on the right of the equals sign minus all values on the left of the equals sign.

How can I change this {[DA]<[Location] to be all selected items?

 

 

=count(distinct {[DA]<[Location]-=P([Group]::[Location])>} [Issue - ID])

2 Replies
sunny_talwar

Not sure what you are trying to do, but to get selected location, why can't you do this:

=Count(DISTINCT {DA} [Issue - ID])

swuehl
MVP
MVP

Not really sure what you want to achieve, to assign all selected values in default set for field Location, try

=count(distinct {[DA]<[Location] = $::[Location])>} [Issue - ID])


or instead $ use Group set identifier:


=count(distinct {[DA]<[Location] =[Group]::[Location] >} [Issue - ID])