topic Filter only 4 weeks in App Development

Filter only 4 weeks

Anonymous — Sat, 23 Jan 2016 16:06:14 GMT

Kindly guide me in below logic. Is it possible to implement it or not?. If yes please help me

In the dashboard, I want to show only four weeks based on the below situations

1. The Week first day is Friday and last day is Thursday

2. In the dimension there will be and only four weeks For E.g.

Scenario for this week:

12/25 - 12/31 - 1 Week

1/1 - 1/7 - 2 Week

1/8 - 1/14 - 3 Week

1/15 - 1/21 - 4 Week

Next Week Scenario:

1/1 - 1/7 - 1 Week

1/8 - 1/14 - 2 Week

1/15 - 1/21 - 3 Week

1/22 - 1/28 - 4 Week

And same goes on.. The current week goes to 4 Week and basis of that the last 3 week calculate

Thanks a lot for your help. Really appreciate it

Thanks

Deepanshu

Re: Filter only 4 weeks

sunny_talwar — Sat, 23 Jan 2016 19:41:40 GMT

The goal is to completely restrict the data for last 4 weeks in the script or are you trying to do this in the chart object?

Re: Filter only 4 weeks

Anonymous — Sun, 24 Jan 2016 04:48:04 GMT

Thanks for the reply.

I want to do it in dimension(Filter) and measure (charts) not in the script

Please suggest.

Thanks

Deepanshu

Re: Filter only 4 weeks

marcus_sommer — Sun, 24 Jan 2016 12:04:39 GMT

I wouldn't say that it couldn't be done within the gui but I recommend to use the script to create these filter-dimensions.

One method could be to use an AsOfTable like described here: Calculating rolling n-period totals, averages or other aggregations and another to create your week-logic within a master-calendar and using of a week-counter (per peek() or autonumber() within the master-calendar) for this field - and then you could use a quite simple set analysis like: sum({< WeekCounter = {">=$(=max(WeekCounter)-4)"}>} YourValues). More valuable informations about master-calendars could you find here: How to use - Master-Calendar and Date-Values.

- Marcus

Re: Filter only 4 weeks

reddy-s — Sun, 24 Jan 2016 20:02:07 GMT

Hi Deepanshu,

If you are looking to display only a fixed number of records make use of the limitations dropdown in the properties pane

Thanks,

Sangram

Re: Filter only 4 weeks

paul_scotchford — Mon, 25 Jan 2016 01:33:13 GMT

I agree with Marcus and setup a good master calendar.

A well thought out master calendar for your enterprise is going to be a big asset and make these types of

calculations very easy.

Re: Filter only 4 weeks

Mon, 25 Jan 2016 10:07:35 GMT

You could look into the WeekStart function

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/weekstart.htm?High…

It allows you to set the day of week as the week start day, as well as an offset

e.g. WeekStart(Today(),-4,4) = 25/12/2015

Combined with Set Analysis, should let you filter down to the last four weeks

Re: Filter only 4 weeks

Anonymous — Sat, 30 Jan 2016 18:22:46 GMT

Thanks Marcus for the help!!

I do this but stuck again:

Let	vStartweek = WeekStart(Today(),-1,4);//Generate Friday of Previous week

Let vEndweek = WeekStart(Today(),0,3);//Generate Thursday of Current Week

can you please guide me how to combine these and name as Week 4. Also, how to calculate the previous three weeks on the basis of 4th Week in just one go in Master Calender.

Please guide me

Thanks

Deepanshu

Re: Filter only 4 weeks

marcus_sommer — Sun, 31 Jan 2016 07:49:05 GMT

Have a look to these new document: Fiscal Calendar with Non-Standard Days (Not 1-31)

- Marcus

Re: Filter only 4 weeks

Anonymous — Sun, 31 Jan 2016 15:07:18 GMT

Thanks sir!!

I tried it but may be very new to Qlik Sense. I am unable to put the above logic.

KIndly guide me the steps. It will be grateful for me.

Thanks in advance for your valuable time!!

Deepanshu

Re: Filter only 4 weeks

marcus_sommer — Mon, 01 Feb 2016 09:48:39 GMT

You could use a simple script like the following to create a master-calendar with a non-calendar week and a weekcounter which based on it:

let vStart = '01.01.2015';

let vEnd = '31.12.2016';

let vCount = num('$(vEnd)') - num('$(vStart)');

for i = 0 to $(vCount)

Calendar:

Load

date('$(vStart)' + $(i), 'DD.MM.YYYY') as Date,

weekday(date('$(vStart)' + $(i), 'DD.MM.YYYY')) as Weekday,

week('$(vStart)' + $(i)) as Week,

month('$(vStart)' + $(i)) as Month,

year('$(vStart)' + $(i)) as Year,

week(WeekStart('$(vStart)' + $(i), 0, 4)) as NonCalendarWeek,

autonumber(week(WeekStart('$(vStart)' + $(i), 0, 4)) & '|' & year('$(vStart)' + $(i))) as WeekCounter

AutoGenerate 1;

and then you could use a set analysis approach like above mentioned:

sum({< WeekCounter = {">=$(=max(WeekCounter)-4)"}>} YourValues)

Note: the Week and NonCalendarWeek might need some adjustments regarding to their start and behaviour by a year-switch to your needed logic. Often is a simple if-loop enough to get the required logic. Also you might prefer another date-format.

- Marcus

Re: Filter only 4 weeks

marcus_sommer — Mon, 01 Feb 2016 09:56:43 GMT

Here are more useful informations:

Redefining the Week Numbers

Redefining the Week Start

- Marcus