topic Re: Variable for weekly report in QlikView

Variable for weekly report

canmarroig — Wed, 09 Apr 2014 10:38:24 GMT

Hi, i need a help, I've a variable to calculate a vDate, in order to produce a weekly report and i need this is calculated only if the first day of month is Monday, if not i need to take Monday on the previous week in order not to loose days over two different months. How can i do? Tks in advance

Re: Variable for weekly report

Anonymous — Wed, 09 Apr 2014 12:09:23 GMT

You can use in script:

Replace today() with your date. vDate will hold the monday, if ihe first day of month ios monday, otherwisethe monday of the previous week of your specified date.

LET vDate=

If (num(weekday(monthstart(today())=0),

makeweekdate(year(today(), week(today()),

makeweekdate(year(today(), week(today()-1))

Is that what you want?

Re: Variable for weekly report

arjunkrishnan — Wed, 09 Apr 2014 12:32:43 GMT

=Date(If(MonthsStart(WeekDay(Today()),0), makeweekdate(year(today()), week(today())),

makeweekdate(year(today()), week(today()-1))),'DD/MMM/YYYY'

)

Re: Variable for weekly report

Anonymous — Wed, 09 Apr 2014 13:05:49 GMT

Sorry, wrong bracket

= Date(If(weekday(MonthStart(Today()))=0,
makeweekdate(year(today()), week(today())),
makeweekdate(year(today()), week(today())-1)),'DD/MMM/YYYY')

Re: Variable for weekly report

Anonymous — Wed, 09 Apr 2014 13:07:13 GMT

Hello Arjun,

I had a wrong bracket.This is correct (I tested it)

=Date(If(weekday(MonthStart(Today()))=0,

makeweekdate(year(today()), week(today())),

makeweekdate(year(today()), week(today())-1)),'DD/MMM/YYYY')

Regards

Rudolf