topic Re: Last Weeks Activity in QlikView

Last Weeks Activity

Wed, 29 Apr 2015 07:50:20 GMT

Hello one and all!

In the dashboard I am in the process of building I am trying to look at just last weeks data, below is how I look at the Year to date data, would someone be able to help me to look at just the last week using the data below as a guide?

if(inmonth ( "Activity_Date", today(), -1 ), Metric_Value, 0) as YTD_Activity,

I also require to look at the previous month as well, so its last week and last month.

Any help much appreciated.

Many Thanks,

Nick

Re: Last Weeks Activity

jpenuliar — Wed, 29 Apr 2015 08:29:56 GMT

Hi NIck,

Have a look at below:

QlikView How To (or Tips & Tricks) Application by Lee Matthews

http://community.qlik.com/docs/DOC-5486

In the files Calendar script, Flags(CurMTDFlag,PriorMTDFlag,CurWeekFlag,PriorWeekFlag) have been used

Re: Last Weeks Activity

Gysbert_Wassenaar — Wed, 29 Apr 2015 08:34:48 GMT

if(InWeek( "Activity_Date" , today(), -1), 1, 0) as InLastWeek

Re: Last Weeks Activity

Wed, 29 Apr 2015 10:15:39 GMT

Thanks for the quick reply!

It doesnt appear to work I'm afraid, do I need to add the 'Metric_Value' as it is below into it somewhere?

if(inmonth ( "Activity_Date", today(), -1 ), Metric_Value, 0) as YTD_Activity

Many thanks in advance,

Nick

Re: Last Weeks Activity

Thu, 30 Apr 2015 07:18:45 GMT

Anyone else got any ideas please?

Also how would I do previous month?

Many Thanks!

Nick

Re: Last Weeks Activity

Thu, 30 Apr 2015 11:18:31 GMT

Hello again,

I've managed to get this to work for previous month, any idea how I could get previous week using the logic below?

if(inmonth ( "Activity_Date", today(), -1 ), Metric_Value, 0) as PreMon_Activity

Many Thanks Qlikers!

Nick