Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to write if statment

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

2 Replies
kunkumnaveen
Contributor III

Re: how to write if statment

but i am not  getting  required o/p

Re: how to write if statment

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))

Community Browser