Date Dimension Is Not Counting Weeks Properly

P_Saltzer — Tue, 06 Sep 2022 19:46:52 GMT

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?

Re: Date Dimension Is Not Counting Weeks Properly

Digvijay_Singh — Wed, 07 Sep 2022 02:38:09 GMT

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

topic Re: Date Dimension Is Not Counting Weeks Properly in Integration, Extension & APIs

Date Dimension Is Not Counting Weeks Properly

Re: Date Dimension Is Not Counting Weeks Properly