Interval over the line

[1adam_haj]

How to deal with wrong format of data ?

I have a table like this

Time 1	Time 2	Interval
2.1.2017 20:00	2.1.2017 21:00	Interval between Time2-and UpperTime1
1.1.2017 20:00	1.1.2017 21:00	Interval between Time2-and UpperTime1

How can i calculate Interval between Time 2 ( Lower line )  and Time 1 ( Upper line  )

Thnaks in advance

[felipedl · Accepted solution]

Hi Adam,

You can do something like:

dummy:

Load * Inline

[

Time 1, Time 2, Interval

2.1.2017 20:00, 2.1.2017 21:00, Interval between Time2-and UpperTime1

1.1.2017 20:00, 1.1.2017 21:00, Interval between Time2-and UpperTime1

];

data:

Load

*,

[Formated Time 2] - peek([Formated Time 1]) as Difference;

Load

RecNo() as Index,

date#([Time 1],'M.D.YYYY hh:mm') as [Formated Time 1],

date#([Time 2],'M.D.YYYY hh:mm') as [Formated Time 2]

Resident dummy;

This gives the following result:

Felipe.

[eduardo_dimperio]

Hi Adam,

Try this

Interval ([Time 2] - [Time 1]) AS Time_Between

Interval – função de script e gráfico ‒ Qlik Sense

[1adam_haj]

Load

RecNo() as Index,

date#([Time 1],'M.D.YYYY hh:mm') as [Formated Time 1],

date#([Time 2],'M.D.YYYY hh:mm') as [Formated Time 2]

Resident dummy;

worked good but

[Formated Time 2] - peek([Formated Time 1]) as Difference;

is not giving any result. I tried to nest it in the Interval but nothing, it didnt worked even without the peek function

[1adam_haj]

Ok i find it out, It worked when i Deleted the # from dates Thank you very much