topic Re: Time to deadline in QlikView

Time to deadline

Thu, 13 Aug 2015 15:15:25 GMT

Hello,

Can any body help me to count time to deadline ?

I have a table

Task Deadline

1 20 Aug 15:00

2 25 Aug 16:00

3 12 Sep 11:00

I would like to count how many 'SS:MM:DD' is form now to this stepping forward deadline

Thank you in advance

Re: Time to deadline

julian_rodriguez — Thu, 13 Aug 2015 15:41:49 GMT

Please find attachement

Re: Time to deadline

Fri, 14 Aug 2015 07:55:08 GMT

Thanks for support

but I would like to have text object which will countdown how many days,hh:mm:ss I have to earliest task not a table

Also I think I have a problem with a date format because if I write:

Day(Date#(Deadline,'DD/MM/YYYY')) as DDay,

Month(Date#(Deadline,'DD/MM/YYYY')) as DMonth,

Year(Date#(Deadline,'DD/MM/YYYY')) as DYear;

in Table viewer is like below

Time format in script I have defaults settings

SET TimeFormat='hh:mm:ss';

SET DateFormat='YYYY-MM-DD';

SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

Thank you in advance

Re: Time to deadline

Fri, 14 Aug 2015 13:58:38 GMT

Can somebody help ?

Re: Time to deadline

yura_ratu — Fri, 14 Aug 2015 14:09:34 GMT

Hi,

Try this

Day(Date#(Deadline,'D MMM hh:mm')) as DDay,

Month(Date#(Deadline,'D MMM hh:mm')) as DMonth,

Year(Date#(Deadline,'D MMM hh:mm')) as DYear;

The problem is - you don't have a year in your Deadline date, so you need to add it manually, something like this

= MakeDate(

2015,

month(date#('8 Aug 11:15', 'D MMM hh:mm')),

day(date#('8 Aug 11:15', 'D MMM hh:mm'))

)

Re: Time to deadline

yura_ratu — Fri, 14 Aug 2015 14:21:22 GMT

Hi,

You need to get your dates in correct format, as I described here Re: Time to deadline

And then calculate difference between today and earliest task TimeDif = min(Deadline) - today(), then do this in texbox

= Floor(TimeDif )&', '&Time(Frac(TimeDif ),'hh:mm:ss')

for getting how many days,hh:mm:ss you have to earliest task in a table

Re: Time to deadline

MarcoWedel — Fri, 14 Aug 2015 22:49:17 GMT

Hi,

one solution could be:

table1:
LOAD *,
    Day(Deadline) as  DDay,
    Month(Deadline) as DMonth,
    Year(Deadline) as DYear;
LOAD Task,
    Timestamp(SetDateYear(Timestamp#(Deadline,'DD MMM hh:mm'),Year(Today())),'DD MMM hh:mm') as Deadline
INLINE [
    Task, Deadline
    1, 20 Aug 15:00
    2, 25 Aug 16:00
    3, 12 Sep 11:00
];

replacing the year with the current year.

hope this helps

regards

Marco