topic Re: Week numbers not correct in QlikView

Week numbers not correct

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I tried to fetch week numbers for the year 2017,but 1/1/2017 is came under week 52.But i need to show it as Week 1.

Note: Week start = Sunday.

Attached is the sample application.

Please find below:

Image1:

Image2:

swuehl — Wed, 22 Mar 2017 09:31:58 GMT

Please have a look at

nareshthavidishetty — Wed, 22 Mar 2017 09:34:57 GMT

Attachment missing in previous post.

Please find the app attached.

Thanks..

nareshthavidishetty — Wed, 22 Mar 2017 11:46:55 GMT

Not able to get using with Henric post.

Please let me know and provide an answer with attached application.

Thanks..

swuehl — Wed, 22 Mar 2017 11:51:54 GMT

I would do it the same way as Henric.

What's the issue with the proposed solution? Where does it fail to reproduce the requested numbers?

How does your modified script look like?

nareshthavidishetty — Wed, 22 Mar 2017 12:08:24 GMT

Hi ,

Please check the attached app and it shows where i'm facing problem.

Thanks..

swuehl — Wed, 22 Mar 2017 12:21:00 GMT

Sorry, you are not using the proposed code in your QVW.

Please try it at least once.

I assume you need these parameter:

Set vCal_FD = 6; // First Day of the week sunday

Set vCal_BW = 0; // Broken Weeks not allowed // not sure here, hasn't been defined yet

Set vCal_RD = 1; // Reference day = 1