Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

period field with two digits

Hi everybody,

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.

Chris

1 Solution

Accepted Solutions
MVP
MVP

Re: period field with two digits

yr & '-' & num(period, '00') AS BuP

3 Replies
MVP
MVP

Re: period field with two digits

yr & '-' & num(period, '00') AS BuP

anbu1984
Honored Contributor III

Re: period field with two digits

yr&'-'&Right('00' & period,2) AS BuP

Not applicable

Re: period field with two digits

thank you so much. You cant imagine, how long I have been searching for that, since I am not part of IT-Department.

Community Browser