topic Re: Date Calculation in QlikView

Date Calculation

kevbrown — Wed, 11 May 2016 13:11:40 GMT

Simple one I'm sure.

I have a table with Date, Issue ID and Issue Category. All i want to do it create a simple table showing the number of issues by issue category but need it for the current week only and last week. My week needs to start on a sunday.

Thanks

Kev

Re: Date Calculation

sunny_talwar — Wed, 11 May 2016 13:15:54 GMT

May be add this as set analysis to your expression:

{<Date = {"$(='>=' & Date(WeekStart(Today(), -1, 6)) & '<=' & Date(Today()))"}>}

Re: Date Calculation

kevbrown — Wed, 11 May 2016 13:20:04 GMT

Sorry, I meant a calculation for this week and another for last week

Re: Date Calculation

avinashelite — Wed, 11 May 2016 13:20:43 GMT

try expression like

// for current week

count({<Date={">(=weekstart(Today(),0,-1))"}>} [Issue ID])

//for last week

count({<Date={">(=weekstart(Today(),-1,-1))"}>} [Issue ID])

Re: Date Calculation

sunny_talwar — Wed, 11 May 2016 13:23:31 GMT

This week: 5/8 - 5/10

{<Date = {"$(='>=' & Date(WeekStart(Today(), 0, 6)) & '<=' & Date(Today()))"}>}

Last Week: 5/1 - 5/7

{<Date = {"$(='>=' & Date(WeekStart(Today(), -1, 6)) & '<=' & Date(WeekEnd(Today(), -1, 6)))"}>}