topic Re: Set Analysis a week ago Dynamic in QlikView

Set Analysis a week ago Dynamic

Anonymous — Wed, 04 Oct 2017 09:28:31 GMT

The following expression shows data based on any data for when the roster date=today.

(Count({<

Sickness_SMART.Roster_RosterDate={'$(=Today())'}

>} [Sickness_SMART.Full Name]))

I want to create the same expression for this day last week, but it returns zero. See below

(Count({<

Sickness_SMART.Roster_RosterDate={'$(=Today()-1)'}

>} [Sickness_SMART.Full Name]))

Any thoughts why it doesn't work

tresB — Wed, 04 Oct 2017 09:32:52 GMT

Try like: (Count({<Sickness_SMART.Roster_RosterDate={'$(=Date(Today()-7))'} >} [Sickness_SMART.Full Name]))

pradosh_thakur — Wed, 04 Oct 2017 09:42:27 GMT

this is why your expression is not working.

1: You have done today()-1 instead of today()-7

2: today()-7 will return you a number not a date

3: Change that number to date by date() function

4: Make sure all your dates are in same format.

The solution is already provided by tresesco and should work

Anonymous — Wed, 04 Oct 2017 09:57:21 GMT

I realised typed 1 on my question, but I meant to type 7.

Thanks

Phil