Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!