Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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])