Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count of IDs on this month but not last month

Hi,

I am trying to ascertain how many IDs were on a report in Jan but not on the report in Feb.  I have had a couple of attempts with Set Analysis but hitting a brick wall:  Current Set Analysis Used:

COUNT(DISTINCT{<BSEG_DT -={">=$(=MonthStart(Today(),-2)) <=$(=MonthEnd(Today(),-2))"},
BSEG_DT ={
">=$(=MonthStart(Today(),-3)) <=$(=MonthEnd(Today(),-3))"}>}SA_ID)

But this just returns the total amount of IDs on the jan report.

Any ideas where I'm going wrong?

Cheers,

1 Solution

Accepted Solutions
sunny_talwar

May be try this

Count(DISTINCT {<SA_ID = p({<BSEG_DT ={">=$(=MonthStart(Today(),-3)) <=$(=MonthEnd(Today(),-3))"}>}) - p({<BSEG_DT ={">=$(=MonthStart(Today(),-2)) <=$(=MonthEnd(Today(),-2))"}>})>} SA_ID)

View solution in original post

2 Replies
sunny_talwar

May be try this

Count(DISTINCT {<SA_ID = p({<BSEG_DT ={">=$(=MonthStart(Today(),-3)) <=$(=MonthEnd(Today(),-3))"}>}) - p({<BSEG_DT ={">=$(=MonthStart(Today(),-2)) <=$(=MonthEnd(Today(),-2))"}>})>} SA_ID)

Anonymous
Not applicable
Author

Perfect Sunny.

Cheers Bud.