Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Week numbers not correct

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:

Untitled.png

Image2:

Untitled1.png

6 Replies
swuehl
MVP
MVP

Please have a look at

Redefining the Week Numbers

nareshthavidishetty
Creator III
Creator III
Author

Attachment missing in previous post.

Please find the app attached.

Thanks..

nareshthavidishetty
Creator III
Creator III
Author

Not able to get using with Henric post.

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

Thanks..

swuehl
MVP
MVP

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
Creator III
Creator III
Author

Hi ,

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

Thanks..

swuehl
MVP
MVP

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