topic Re: Last x Days in QlikView

Last x Days

Tue, 08 Apr 2014 10:38:39 GMT

Hi Qlik Community,

I'm having troubles with date grouping. I want to be able to select data for the last 'x' number of days (last 7 days, last 30 days etc). I have some date grouping working fine (Today, Yesterday, This Week, Last Week etc.) but can't find a way to get the last x days.

I've attached a modified version of the excellent 'Date-Grouping.qvw' from the Qlikview Cookbook (Thanks Rob!). I've tried modifying the Inline table directly:

Last 7 Days; vToday; vToday-7

Which doesn't work. I've also tried assigning a variable:

LET vLast7Days=Date(today(1)-7);

...

Last 7 Days; vToday; vLast7Days

Which also doesn't work. I've stepped through the script load and the variables seem to assign properly but the end result is still not working.

Any help would be much appreciated!

Damien.

Re: Last x Days

MK_QSL — Tue, 08 Apr 2014 10:53:03 GMT

I think below link will help you on your question.

A Rapid "Fast Calendar Selections...", a great boost of multi periods analysis! ...

Re: Last x Days

tresB — Tue, 08 Apr 2014 10:53:40 GMT

A small mistake, the ordering of the variables were wrong in the inline part, correct it as:

Range; RangeStart; RangeEnd

Last 7 Days; vLast7Days; vToday

Last 30 Days; vLast30Days; vToday

I.e.- vToday should be there under RangeEnd instead of RangeStart.

Re: Last x Days

Tue, 08 Apr 2014 11:05:19 GMT

Argh, so simple. Many Thanks