topic Re: Getting count for last week in QlikView

Getting count for last week

deepakqlikview_123 — Tue, 01 Sep 2015 10:07:20 GMT

I need to get count for last week( current week -1) i am using below expression but it is not working

can you please suggest on this

=count({$<RAG_STATUS={'Red'} , WEEK_DATE={$(=Date([WEEK_DATE]-7))}>} distinct[Release ID])

sunny_talwar — Tue, 01 Sep 2015 10:10:06 GMT

Try this:

=Count({$<RAG_STATUS={'Red'} , WEEK_DATE={"$(=Date(Max([WEEK_DATE])-7))"}>} Distinct [Release ID])

Also make sure that WEEK_DATE and the expression $(=Date(Max([WEEK_DATE])-7)) gives the same format.

sunny_talwar — Tue, 01 Sep 2015 10:14:15 GMT

Also do you need the count for a day or the whole week (7 days)?

For a week, try this may be:

=Count({$<RAG_STATUS={'Red'} , WEEK_DATE={"$(='>=' & Date(Max([WEEK_DATE])-14) & '<=' & Date(Max([WEEK_DATE])-7))"}>} Distinct [Release ID])