Problem to call data

[MRuiz]

Hi everyone,

I'm new on QlikSense only few month of practice.

My question is simple : Is it possible in the same table to call a data in function of an other data ?

I have a table like this :

Date | Date2 | Hours

I want to call "Hours" in function of "Date" or "Date2" because depending on the date "Hours" is not the same result

I hope my question is clear

Thanks for your help !

[Channa]

clear make it more 

[MRuiz]

My table is like that (example):

Date          |    Date 2      | Hours

08/02/19      08/02/19    0,5
10/02/19     10/02/19    1,5
12/02/19     12/02/19    5,7

Can I make something like LOAD "Hours" from "Date" or LOAD "Hours" from "Date2" ??

Because I know it's weird but in function of Date or Date2 the result is not the same 🙂

[Channa]

you like to extract Time from date2

time(date2)

if you want to find difference between those 2 fields

=Interval( Date1-Date2, 'D')