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

saumyashah90 — Sat, 16 Nov 2024 18:21:26 GMT

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

Re: Ignore Selection in P() or E() with filter selection

sunny_talwar — Thu, 16 Jul 2020 12:52:39 GMT

Try this

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

topic Re: Ignore Selection in P() or E() with filter selection in QlikView

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

Re: Ignore Selection in P() or E() with filter selection