Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Are you trying to display your time in Military Time format? As in, 6 am is 0600 and 8 pm is 2000?
Try this if that's what you meant.
//Script
SET TimeFormat='hh:mm:ss TT';
Expression syntax: Timestamp('YourTimeField' ,'hh:mm:ss')
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')
Could you elaborate more?
1 - 0600
2 - ?
3 - ?
4 - ?
5 - ?
6 - ?
What does it stand for?