topic Re: relabel values in dimension field in QlikView

relabel values in dimension field

drohm002 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: relabel values in dimension field

qlikwiz123 — Tue, 16 Oct 2018 17:48:53 GMT

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

Re: relabel values in dimension field

qlikwiz123 — Tue, 16 Oct 2018 18:00:16 GMT

Try this if that's what you meant.

//Script

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

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

Re: relabel values in dimension field

Anil_Babu_Samineni — Wed, 17 Oct 2018 03:23:52 GMT

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')

Re: relabel values in dimension field

MindaugasBacius — Wed, 17 Oct 2018 06:36:03 GMT

Could you elaborate more?

1 - 0600

2 - ?

3 - ?

4 - ?

5 - ?

6 - ?

What does it stand for?