Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
hjm35055
Partner - Contributor III
Partner - Contributor III

Formatting period from 2 sources to be the same

Hi,

I have period coming from 2 sources.  The one is in the form of 1, 2, 3, 4, 5...  The other is 01, 02, 03, 04....  I need to get them to be the same format.  Does not matter if there is a 0 or not.

Thank you,

1 Reply
sunny_talwar

May be just this

period * 1 as period