Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Search instead for
Did you mean:
Specialist

## Ignore Selection in P() or E() with filter selection

I have this expression.

Comparison between two months.  RightMonth is the current selection(under [Asof Date])

"Resigned"=& Count(DISTINCT{<[Employee ID] = e({<[Asof Date] = {'\$(vRightMonth)'}>}[Employee ID]), [Employee ID] = p({<[Asof Date] = {'\$(vLeftMonth)'}>}[Employee ID])>}[Employee ID])

This gives me result of count common between Left and Right Month.

I want to find employee count which were present in leftMonth(lowermonth) but not present in rightMonth(highermonth).

This will give me people who resigned.

Whats wrong?

I cannot do anything in script. need to to do in UI only with expression.

Your help would be thankful

Labels (2)

• ### Set Analysis Modifiers

1 Solution

Accepted Solutions
MVP

Try this

``"Resigned" & Count(DISTINCT{<[Employee ID] = e({<[Asof Date] = {'\$(vRightMonth)'}>} [Employee ID]) * p({<[Asof Date] = {'\$(vLeftMonth)'}>}[Employee ID])>} [Employee ID])``

1 Reply
MVP

Try this

``"Resigned" & Count(DISTINCT{<[Employee ID] = e({<[Asof Date] = {'\$(vRightMonth)'}>} [Employee ID]) * p({<[Asof Date] = {'\$(vLeftMonth)'}>}[Employee ID])>} [Employee ID])``

Community Browser