Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
New Contributor III

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
yujiyamane
Contributor II

Re: TWO DIGIT WEEK #

It should be as below.

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

1 Reply
yujiyamane
Contributor II

Re: TWO DIGIT WEEK #

It should be as below.

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