Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
akuttler
Contributor

TWO DIGIT WEEK #

I have a custom dimension for Year Week# as follows:


= Year(Date) & ' ' & (Week([Date])



How would I make the week # always appear as two digits for example

2018 01

2018 02


etc.


Thanks.

1 Solution

Accepted Solutions
Highlighted
yujiyamane
Contributor II

Re: TWO DIGIT WEEK #

It should be as below.

= Year(Date) & ' ' & num( Week([Date]), '00')

View solution in original post

1 Reply
Highlighted
yujiyamane
Contributor II

Re: TWO DIGIT WEEK #

It should be as below.

= Year(Date) & ' ' & num( Week([Date]), '00')

View solution in original post