Discussion Board for collaboration related to QlikView App Development.
I have a table
My senario is if i have my First_time as null then i should use Next_time
If i have First_time then i should First_time
If i have First_time as null use Next_time and later at any time i got the First_time i should use only Next_time, i dont want to change again to First_time
My output is
if(isnull(First_Time),Next_Time,First_Time) as Final_Time
On which basis the data will change in First_Time field?
Try this also:
If(Case = Peek('Case'), Peek('Final_time'), If(Upper(First_Time) = 'NULL', Next_time, First_Time)) as Final_time
(html, codepage is 1252, embedded labels, table is @1);
Hi sunny your code has worked out but i have another senario which is causing the problem the below is the table
What is the issue? Would you be able to elaborate?
the issue is
if there is no FIRST_TIME make Min_time as out_put
if there is no FIRST_TIME and later came FIRST_TIME we should make Min_time as out_put
if there is FIRST_TIME and Min_time make FIRST_TIME as out_put (even though we got the FIRST_TIME later)
but i'm facing issue for B234 customer where we are getting the FIRST_TIME later