relabel values in dimension field

[drohm002]

I am making a chart in qlikview, of the table variety.  I have a field called TIME_DAY, which I want to make a dimension.  The values inside TIME_DAY are  1, 2, 3, 4, 5, 6.  How can I display values of '1' as '0600'?

Thanks!

[qlikwiz123]

Are you trying to display your time in Military Time format? As in, 6 am is 0600 and 8 pm is 2000?

[qlikwiz123]

Try this if that's what you meant.

//Script

SET TimeFormat='hh:mm:ss TT';

Expression syntax:   Timestamp('YourTimeField' ,'hh:mm:ss')

[Anil_Babu_Samineni]

How can I display values of '1' as '0600'?

What is the Logic behind? For me, This is like Date(MakeTime(Num#(TIME_DAY)+5),'hhmm')

[MindaugasBacius]

Could you elaborate more?

1 - 0600

2 - ?

3 - ?

4 - ?

5 - ?

6 - ?

What does it stand for?