Set analysis not satisfying all conditions

ipauldur — Wed, 01 Aug 2012 03:17:16 GMT

Hi All,

I am using the below expression in the pivot trable.

Sum ({<YearMonth={"$(vReport_YearMonth)"},Revised_GTO_Flag={1},GTO_Flag={1},_Data_Option={1}>}Area_Less_NTD)

Actually, i have the field "Revised_GTO_Flag" field in the table. But there is nothing (Value) for this field. So when i include in the expression its showing the value for satisfied all other conditions. Originally, i should get zero for this expression.

Please suggest me, how to modify this expression for getting zero value.

Thanks,

Durai.

Re: Set analysis not satisfying all conditions

Sun, 12 Aug 2012 09:06:31 GMT

Hi,

Try the below expression.

Sum ({<YearMonth={"$(vReport_YearMonth)"},Revised_GTO_Flag={"1"},GTO_Flag={"1"},_Data_Option={"1"}>}Area_Less_NTD)

Regards,

Desmortes

topic Set analysis not satisfying all conditions in QlikView

Set analysis not satisfying all conditions

Re: Set analysis not satisfying all conditions