If condition is giving wrong values

alec1982 — Wed, 12 Sep 2012 03:53:26 GMT

Hi guys,

Can anybody figure out what's wrong with this If statement! it is giving value of 180 instead of 77!!

if (

Sum( if ( ((Index([Expense Type (annual)], 'Rent') = 0) or GetFieldSelections(_ShowRentFlag)=1)

and ([Year of Expense] = $(varPlReportingYear))

,[Amount of Expense (USD-annual)]

))

> 0

Sum(if ( ((Index([Expense Type (annual)], 'Rent') = 0) or GetFieldSelections(_ShowRentFlag)=1)

and ([Year of Expense] = $(varPlReportingYear))

, [Amount of Expense (USD-annual)]

)

) / 1000

)

I appreciate any help.

Thxs,

Alec

Re: If condition is giving wrong values

Jason_Michaelides — Wed, 12 Sep 2012 06:32:34 GMT

I think you'll need to post your app to get such specific help! However, I can't see a second part of the If statement...what if the evaluation condition is not true? (I'm on a train and may have misread it...)

topic If condition is giving wrong values in QlikView

If condition is giving wrong values

Re: If condition is giving wrong values