Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Maximum value with nested if ciondition

Hi

I have a table

Table

Swipe in time     employee       get in time

11-12-2015        john                21-07-2015

    null( -)            john                17-12-2015

14-11-2015        john                14-11-2015

i want a condition in the script that if my Swipe in time is greater than get in time i want to use the get in time

if my Swipe in time has null value then i want to use the get in time else i want  to use Swipe in time

my out put is

swipe in time

21-07-2015

17-12-2015

14-11-2015

2 Replies
sunny_talwar

May be this:

Table:

LOAD [Swipe in time],

  If(Len(Trim([Swipe in time])) = 0 or [get in time] > [Swipe in time], [get in time], [Swipe in time]) as [New Swipe in time],

  employee,

  [get in time];

LOAD * Inline [

Swipe in time,     employee,       get in time

11-12-2015,        john,         21-07-2015

   ,        john,         17-12-2015

14-11-2015,        john,         14-11-2015

];


Capture.PNG

maxgro
MVP
MVP

maybe

load

     ...,

     Date(rangemin([Swipe in time], [get in time])) as NewField,

.....