topic Re: create new column in QlikView

create new column

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

Hi all,

I have a time table and opentime in main table

I want to create a new column based on that like

opentime+time as DeadlineTime

how to create this ?

Main table column[open time] created like below

Time#(Right("OpenTime",8),'hh:mm:ss') as "Open Time"

Time table:

Load * Inline [

PId,Time[In minitue]

1,15

2,30

3,600

4,120

];

how can I achieve this?

Thanks

Sony

Re: create new column

Anil_Babu_Samineni — Sun, 15 Oct 2017 09:44:35 GMT

Try this? If Time is in Hours..

[Open Time] + Date(Date#("Time [In minute]", 'hh'), 'hh:mm:ss') as New_Column;

Re: create new column

soniasweety — Sun, 15 Oct 2017 10:26:33 GMT

not working because my open time column values giving wrong

how to set to this correct hh:mm:ss format

this is giving output below not working

Time#(Right("OpenTime",8),'hh:mm:ss') as "Open Time"

Re: create new column

Anil_Babu_Samineni — Sun, 15 Oct 2017 10:29:39 GMT

May be this?

=Date(Num#(Right("OpenTime",8)),'hh:mm:ss') as "Open Time"

Re: create new column

soniasweety — Sun, 15 Oct 2017 10:34:48 GMT

its givng like below

Re: create new column

Anil_Babu_Samineni — Sun, 15 Oct 2017 10:36:51 GMT

Can you share the sample file to test

Re: create new column

soniasweety — Sun, 15 Oct 2017 10:46:16 GMT

not possible

Re: create new column

Anil_Babu_Samineni — Sun, 15 Oct 2017 10:47:29 GMT

No need to share, Server one. You ca create 2 fields which is Time and OpenTime to check from real data values..

Re: create new column

Or — Sun, 15 Oct 2017 13:33:11 GMT

Interval(Time#(Right("OpenTime",8),'hh:mm:ss') + (Time[In minitue]/1440))

When using math operators with time 1.0 equals one day, so divide minutes by 1440 minutes (in one day). Format as interval (NOT as time), or anything that took over 24 hours will show up incorrectly.

Re: create new column

soniasweety — Mon, 16 Oct 2017 13:08:22 GMT

still no luck its giving null

Re: create new column

Or — Tue, 17 Oct 2017 10:28:04 GMT

I checked that syntax and it works. If it doesn't, check your data and column names.