topic Select a week from a selected date in a macro in QlikView

Select a week from a selected date in a macro

urivera — Wed, 02 Sep 2009 22:57:16 GMT

hi all,

In a macro i wrote a code that select a year, month and day, I select the values from today() function. In a model i have too a year-week, i need to select this field from another data, ie, year + month + day, all in a macro...

If i use the function week() in a macro it does not work.

any idea...?

thks.

Select a week from a selected date in a macro

Wed, 02 Sep 2009 23:08:15 GMT

try with datepart("ww", date)

Select a week from a selected date in a macro

Wed, 02 Sep 2009 23:10:32 GMT

What format is your week column in? We use WWYYYY a lot.

Week() will give you the WW and WeekYear() should give you the YYYY. You probably want:

Week(Today()) & WeekYear(Today())

Select a week from a selected date in a macro

urivera — Wed, 02 Sep 2009 23:25:44 GMT

hi Dragonauta,

Do you speak spanish?, ok, can you explain datepart function pls, i cannot find this command in QV manuals...

thks.

Select a week from a selected date in a macro

Wed, 02 Sep 2009 23:32:34 GMT

I don't think DatePart is a QlikView function. I know it exists in T/SQL and VBScript though.

Select a week from a selected date in a macro

Thu, 03 Sep 2009 00:18:17 GMT

sí hablo español.

datepart es una función de vbscript, porque según entiendo lo quieres usar en una macro, no? Y ahí puedes usar vbscript y/o jscript.

aquí hay más información de la función si quieres:

http://www.w3schools.com/VBscript/func_datepart.asp