Make WeekNumber.Year date out of normal date with ... - Qlik Community

QlickySense · ‎2021-09-29

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 · ‎2021-09-29

Try WeekName(YourDate) instead.

tresesco · ‎2021-09-29

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

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