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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
P_Saltzer
Contributor
Contributor

Date Dimension Is Not Counting Weeks Properly

Hi All,

I have a dimension called "Data Concern Creation Date" that I'm trying to use in a bar chart and I'm having two problems.  The first is that while the field is classified properly as a date field it only shows the date when using the top most dimension.  If I try to have it organized by week using "Data Concern Creation Date.InWTD" it's grouped together as zero and one.  The second problem has to do with the counting of weeks.  I have a concern with a date of 08/22/2022.  If I use the "Data Concern Creation Date.Week" option it ends on W34.  August 22, 2022 falls on week 35 however.  What do I need to do to fix it?

Labels (1)
1 Reply
Digvijay_Singh
MVP
MVP

If possible share sample data and the expected output 

https://community.qlik.com/t5/QlikView-App-Dev/How-to-get-answers-to-your-post/td-p/268841