Discussion Board for collaboration related to Creating Analytics for QlikView.
I hope someone of you could help me.
I am trying to Show a period-field with two Digits but I dont get it to work.
The Problem is that the period field is not part of a calender. It is just one field with number from 1-12.
(It is the used period, the date can be different from that period, therefore it is not part of the calendar.
I tried yr&'-'&period, '00' AS BuP, but this does not work.
How can I get 01 until 09 for the months January to September?
Does someone of you have an idea?
Very much thanks in advance.
Go to Solution.
yr & '-' & num(period, '00') AS BuP
yr&'-'&Right('00' & period,2) AS BuP
thank you so much. You cant imagine, how long I have been searching for that, since I am not part of IT-Department.