topic Re: Make WeekNumber.Year date out of normal date with sorting option in QlikView

Make WeekNumber.Year date out of normal date with sorting option

QlickySense — Wed, 29 Sep 2021 10:29:38 GMT

Hello,

I've got my problem solved partly but I think i need a little help here

I got normal dates like

FYI: It is just a grasp of data and the chart below is not reflecting this table 1:1

I can create a date like Week Number and Year by

Week(MyDate) & ' ' & WeekYear(MyDate) as MyNewDates, but in a chart it is completely mess like in the capture

1. Is my approach proper?

2.How to make this field numeric(?) to let it goes in order of years and weeks?

3. Ideally I would like to have it presented as
Week 4, Week5
2020, 2021

Is it possible to create?

Or — Wed, 29 Sep 2021 10:30:21 GMT

Try WeekName(YourDate) instead.

tresB — Wed, 29 Sep 2021 10:37:52 GMT

The above solution should work fine. However, if you are very particular about the format, try with dual() as I suggested in your another thread, here: https://community.qlik.com/t5/QlikView-App-Dev/Make-a-weekdate-weekly-intervals/m-p/1839961#M1215204