topic Re: Maximum value with nested if ciondition in QlikView

Maximum value with nested if ciondition

Sun, 31 Jan 2016 14:39:11 GMT

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

sunny_talwar — Sun, 31 Jan 2016 16:07:49 GMT

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

];

maxgro — Sun, 31 Jan 2016 17:00:42 GMT

maybe

load

...,

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

.....