Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

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