topic Re: Data Foemate in QlikView

Data Foemate

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

I have two fields in table, Metrics and Values, Data look like image that i have uploaded. I have created one more column as formate. metrics which are in red colour having number values, metrics which are in yellow colour having Time values and metrics which are in green colour having days values.

Metrics which are in yellow colour having Time values but it actual in number format and i want to convert it into time format as hh:mm:ss.

Please help me how can i change number format into time.

Thanks,

Villyee.

Re: Data Foemate

Gysbert_Wassenaar — Thu, 17 Mar 2016 16:27:59 GMT

If the Values is 73 then what should it look like in Time format?

Re: Data Foemate

Chanty4u — Thu, 17 Mar 2016 16:37:21 GMT

chk dis

Converting time to number : hhhh:mm:ss towards number,decimal

Re: number to time converstion

Convert number values into time

Re: Data Foemate

Kushal_Chawda — Thu, 17 Mar 2016 17:10:10 GMT

Time value in number is in second or in minute?

If it is in Seconds then try below

=if(Format='Time' ,num(Floor($(vSec)/3600),'00')&':'&num(floor(Mod($(vSec),3600)/60),'00')&':'&Mod(Mod($(vSec),3600),60),Value)

replace $(vSec) by Value

Re: Data Foemate

MarcoWedel — Fri, 18 Mar 2016 00:01:04 GMT

Hi,

maybe something like this?

table1:
LOAD Metrics,
    Pick(Match(Formate,'Number','Time','Days'),Values,Interval(Values/24/60,'hh:mm:ss'),Dual(Values&' d',Values)) as Values
Inline [
Metrics,Values,Formate
AAAA,23,Number
GGGG,73,Time
LLLL,54,Days
];

(assuming your time values are minutes as you did not specify)

hope this helps

regards

Marco