Discussion Board for collaboration related to QlikView App Development.
I have a list of time and want to know if they are in the future or past compare to now.
so expecting to see:
any idea, I tied to play with the interval function but not sucess yet...
LOAD * INLINE [
Use as expression :
See the attached .qvw.
View solution in original post
If(MyTime>=Frac(Now()), 'Future', 'Past')
I know its already answered, but the solution doesn't work for me. My solution is:
Load *, If(Diff>0, 'Future', 'Past') as Flag_TIME;
Load *, Num(MyTime)-num(Time(Now())) + Num(Today()) as Diff, Time(Now()) as Now;
The result is