Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

week() with more than 1 parameter generates script error in qlikview 11

Hi!

I am having problems when loading my script in qlikview 11. I used the function week(field,0,1) in order to use broken weeks, it loads succesfully in qlikview 12, but in qv 11 I got the following error:

error2.jpg

Please, can anybody explain me the reason of that error?

1 Solution

Accepted Solutions
thomaslg_wq
Creator III
Creator III

Hi,

The reason is :

QV11 takes only one parameter : Timestamp

QV12 can take 4 parameters  : Timestamp, First week day, broken weeks, reference day

You can see it quickly by writing only the start of the sentence 'week(' and you'll get a pop up with waited parameters.

View solution in original post

2 Replies
thomaslg_wq
Creator III
Creator III

Hi,

The reason is :

QV11 takes only one parameter : Timestamp

QV12 can take 4 parameters  : Timestamp, First week day, broken weeks, reference day

You can see it quickly by writing only the start of the sentence 'week(' and you'll get a pop up with waited parameters.

Not applicable
Author

Thank you Thomas!