This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Please can anyone help on this.
I have a duration field which is containing the data like below.
For these above records i need convert in to decimal values and multiply with 24.
For 1d 01:25:22 and 4d -> i know that we need to split and multiply by 24 then we need to add both the values.
how to convert and multiply with duration and main challenging with 1d and 4d.
Attached the excel for reference.
LOAD *, IF(IsNum(Duration), Duration*24, Num((Left(StrDuration,1)*24)+ (Subfield(StrDuration, ' ',2)*24))) AS FinalDurationInt;
//LOAD *, Subfield(StrDuration, ' ',2) AS StrDurationTime;
IF(NOT ISNUM(Duration), Interval#(Replace(Duration, 'd',''), 'd h:mm:ss')) AS StrDuration,
Replace(Duration, 'd','') As Duration,
[New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Sheet1);
View solution in original post
You are give a good suggestion to me,its working.
Happy to hear. Please close the thread by marking Correct Answer.