topic Re: how to write if statment in QlikView

how to write if statment

kunkumnaveen — Mon, 18 Apr 2016 11:24:52 GMT

HI,

can any one says whats wrong in thisexpression,expression seem ok but i am getting required o/p

if(FirstSortedValue( {<ROLE={'EVAL'} >}TOTAL_SCORE, -DATE_OF_REVIEW)=0,0,FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=, >}TOTAL_SCORE, -DATE_OF_REVIEW))

thanks

naveen

Re: how to write if statment

kunkumnaveen — Mon, 18 Apr 2016 11:25:27 GMT

but i am not getting required o/p

Re: how to write if statment

sunny_talwar — Mon, 18 Apr 2016 11:28:24 GMT

May be this:

if(IsNull(FirstSortedValue( {<ROLE={'EVAL'} >}TOTAL_SCORE, -DATE_OF_REVIEW)), 0, FirstSortedValue(Distinct {<ROLE={'SELF_EVAL'}, SUPCAT=>}TOTAL_SCORE, -DATE_OF_REVIEW))