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: 
saumyashah90
Specialist
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)
1 Solution

Accepted Solutions
sunny_talwar

Try this

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

 

View solution in original post

1 Reply
sunny_talwar

Try this

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