topic Re: correct format in QlikView

correct format

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

Hi all,

I want to set it to timestamp format like hh:mm:ss how can I achieve this?

usning this :

if([Timestamp Num]> $(vToday), (Fabs($(vToday) - [Timestamp Num])))

variable -vToday: =num(Timestamp(Now(),'MM/DD/YYYY hh:mm:ss'))

current output: 0.07 ,0.10 like that

required output: 01:20:01 like this [its example output]

Re: correct format

felipedl — Tue, 24 Oct 2017 11:03:54 GMT

Hi Sony,

Your variable vToday is formating the timestamp as a number with num().

Try taking it out and see the result.

Felipe.

Re: correct format

sunny_talwar — Tue, 24 Oct 2017 11:12:27 GMT

Do you need the current time?

LET vToday = Time(Frac(Now()), 'hh:mm:ss');

Re: correct format

soniasweety — Tue, 24 Oct 2017 11:18:56 GMT

after removing it is giving null

Re: correct format

soniasweety — Tue, 24 Oct 2017 11:19:19 GMT

no sunny its giving null

Re: correct format

sunny_talwar — Tue, 24 Oct 2017 11:21:28 GMT

It is giving null? that can't be true.... I tried and it is working well

Re: correct format

felipedl — Tue, 24 Oct 2017 11:23:04 GMT

Hi sony,

Putting the formula into a text box:

=Timestamp(Now(),'hh:mm:ss')

gives the following !

Re: correct format

felipedl — Tue, 24 Oct 2017 11:23:57 GMT

It's probably giving null because his condition for

if([Timestamp Num]> $(vToday), (Fabs($(vToday) - [Timestamp Num])))

isn't met.

Re: correct format

sunny_talwar — Tue, 24 Oct 2017 11:25:40 GMT

Oh I see... I guess this will now need to use a single quote around the variable

if([Timestamp Num]> '$(vToday)', (Fabs('$(vToday)' - [Timestamp Num])))

Re: correct format

soniasweety — Tue, 24 Oct 2017 12:12:51 GMT

this also no luck I don't know why

Re: correct format

soniasweety — Tue, 24 Oct 2017 12:14:31 GMT

my field format is like this below that's why I used num in variable

42860.08154

42860.13194

42860.16713

42860.19242

42860.20373

42860.20534

42862.93403

Re: correct format

sunny_talwar — Tue, 24 Oct 2017 12:16:38 GMT

Try this

LET vToday = Num(Now())

and then this:

Interval(If([Timestamp Num] > $(vToday), (Fabs($(vToday) - [Timestamp Num]))), 'hh:mm:ss')

Re: correct format

soniasweety — Tue, 24 Oct 2017 12:25:40 GMT

Nothing same null,

but variable is working in text object sunny

but expression is not working

Re: correct format

soniasweety — Tue, 24 Oct 2017 12:26:40 GMT

field is calucalted like this

Timestamp#(Date(RDDate)&' '&Time(RDTime,'hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')

Re: correct format

sunny_talwar — Tue, 24 Oct 2017 12:27:55 GMT

Would you be able to share a sample?

Re: correct format

soniasweety — Tue, 24 Oct 2017 13:59:07 GMT

working this sunny

if([Timestamp Num]> $(vToday), Interval(Fabs($(vToday) - [Timestamp Num]),'hhh:mm:ss'))

Re: correct format

sunny_talwar — Tue, 24 Oct 2017 14:09:05 GMT

With three h? or is that a typo

Re: correct format

soniasweety — Tue, 24 Oct 2017 14:43:25 GMT

yes its working fine enough

Re: correct format

sunny_talwar — Tue, 24 Oct 2017 14:48:34 GMT

Okay, but I think it should work with two h also (and probably the right syntax even though 3 h works)

if([Timestamp Num]> $(vToday), Interval(Fabs($(vToday) - [Timestamp Num]),'hh:mm:ss'))