topic Help with Date Set Analysis in QlikView

Help with Date Set Analysis

prees959 — Fri, 22 Nov 2019 16:52:12 GMT

Hi,

I would like to make a slight change to a the "Days since Last Accessed" expression from the Governance Dashboard.

At the moment the expression is (Interval(today()-max(daystart([Session Start])),'D')) . But is it possible to limit this to those users who only logged in last full month (eg : 01 Oct to 31st Oct) and who haven't yet logged in this month?

Many thanks

Phil

Re: Help with Date Set Analysis

Stoyan_Terziev — Fri, 22 Nov 2019 17:45:14 GMT

Hi,

Try this:

(Interval(today()-max({<[Session Start]={">=$(=TimeStamp(Monthstart(Addmonths(Today(), -1))))"}>}daystart([Session Start])),'D'))

Re: Help with Date Set Analysis

prees959 — Fri, 22 Nov 2019 18:06:27 GMT

Many thanks for your reply!

Thats sort of there.... its still including users that logged in this month. Can this months users be excluded?

Re: Help with Date Set Analysis

Stoyan_Terziev — Sat, 23 Nov 2019 09:47:24 GMT

Hi Prees,

Try this:

(Interval(today()-max({<[Session Start]={">=$(=TimeStamp(Monthstart(Addmonths(Today(), -1))))<=$(=TimeStamp(MonthEnd(Addmonths(Today(), -1))))"}>}daystart([Session Start])),'D'))