topic WeekName formats in QlikView

WeekName formats

mazacini — Mon, 21 Sep 2015 08:01:15 GMT

I have created a variable

LET vRepWeek = WeekName(Today());

It creates a value 2015/38 for the current week.

I am trying to compare this date to a LastSaleWeek created in my script

WeekName(Max(WeekName)) as LastSaleWeek,

I am trying to compute the difference between these two values.

Problem is that the VRepWeek is being interpreted by Qlikview as a number 53.0262 ie 2015 divided by 38 (2015/38).

As you can see, the two fields have different formats.

Any suggestions?

Re: WeekName formats

alexandros17 — Mon, 21 Sep 2015 08:05:49 GMT

when I manage weeks and Year I use to write expression like:

WeekYear(myDate)*100 + Week(myDate)

this expression returns the number 201538 that can be managed easily ...

Re: WeekName formats

mazacini — Mon, 21 Sep 2015 08:15:20 GMT

Thanks Alessandro.

I actually do something similar in Excel.

But us 201538 a number?

How would this work across multiple years? If I wanted to establish the interval between 201438 and 201505, how would this compute?

Regards

Joe

Re: WeekName formats

alexandros17 — Mon, 21 Sep 2015 08:22:53 GMT

Only an idea ... use the starting dates of weeks then make a difference between 2 dates and divide by 7:

Suppose that the date (DT1) 17 Sep 2014 gives you the week 201438 and (DT2) 28 Jan 2015 is the 201505 then

(WeekStart(DT2) - WeekStart(DT1))/7 returns the number of weeks between the two.

let me know

Re: WeekName formats

tresB — Mon, 21 Sep 2015 08:23:41 GMT

Possibly you are using $ expansion to that variable which is then converting the texual presentation to evaluated number. Try without $ with variable.

Re: WeekName formats

sasiparupudi1 — Mon, 21 Sep 2015 08:54:58 GMT

Try

=WeekName(Today(1))- weekname(makedate(SubField('2014/02','/',1)),SubField('2014/02','/',2))

hth

Sasi

Re: WeekName formats

mazacini — Mon, 21 Sep 2015 12:09:13 GMT

Thank you for your response.

When I drop the dollar expansion, the script does not seem to recognise the variable.

Is there a particular syntax I should be using?

Regards

Joe

Re: WeekName formats

tresB — Mon, 21 Sep 2015 12:21:09 GMT

Could you share your qvw sample?