- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Week display
Hi Guys, i have one issue here where if we see in the image its showing 52,52 until 46 then it goes to 15. The thing i wanted to achieve is the Week 52 till 46 is the historical weeks while 15 to 1 is the updated weeks. So how to align the week accordingly for example like 51,50,49,48,47,46,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15. 15 is the latest updated week. Can anyone help me on this.
Thanks and regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i sugget to use dual() function to assing to each week number the correct sort order.
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just Use sort by Measure = Date
or if you have a yearWeek field in your model like like = WeekYear(Date)&'-'&Week
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Michele De Nardi,
but the solution you give is referring to Qlikview whn i click the dual() link.
Regards,
Hafiz
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Vineeth Pujari,
Can you explain or show me the example as I'm new to Qlik Sense I don't really get what you're saying.
Regards,
Hafiz
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As below
temp:
Load
Date
,Week(Date,0,0) as Week
,WeekYear(Date,0,0)&num(Week(Date,0,0),'00') as YearWeek
;
Load Date(iterno()-1 + Date#('2021-11-01','YYYY-MM-DD')) as Date
Autogenerate 1
While Date(iterno()-1 + Date#('2021-11-01','YYYY-MM-DD')) - Date#('2022-02-28','YYYY-MM-DD')
;
exit Script;
In Chart
If a post helps to resolve your issue, please accept it as a Solution.