Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Creator III
Creator III

Variable - Display "week of..."

Hi - 

The following displays the week of the year for a given specific date :

Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber', '$cyclic'),

 

Example :

W10

 

I am looking for another option to display instead of W10 to display something like :

"Week of 7/27/2020"

"Week of 8/3/2020"

Thus - the monday of the week for the specific date.

 

Thanks - Jerry

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

try below

Dual('Week of '&weekstart($1,0,0), weekstart($1,0,0)) AS [Week] Tagged ('$weeknumber', '$cyclic')

View solution in original post

2 Replies
Kushal_Chawda

try below

Dual('Week of '&weekstart($1,0,0), weekstart($1,0,0)) AS [Week] Tagged ('$weeknumber', '$cyclic')
Vegar
MVP
MVP

I believe that @Kushal_Chawda suggested solution will do the trick, but I would no longer used the $cyclic tag as the values are no longer cyclic when using start date instead of week number.