Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted

Re: Count of IDs on this month but not last month

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
Highlighted

Re: Count of IDs on this month but not last month

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

Highlighted
Contributor II
Contributor II

Re: Count of IDs on this month but not last month

Perfect Sunny.

Cheers Bud.