topic Sum Expression in QlikView

Sum Expression

Wed, 25 Aug 2010 14:52:19 GMT

Hi I would like to know if this expression is correct or not.

SUM( {$<Gestion.FechaRegistro={"<=$(#vFFG) >=$(#vFIG)"} , Gestion.CodigoCliente ={ 'CNA009002'}>, }Gestion.Qty)

Thanks

Wed, 25 Aug 2010 15:17:16 GMT

Are you getting an error? Null?

The only thing I see is equal signs (not #s) in the dollar sign expansions:

=SUM( {$<Gestion.FechaRegistro={'<=$(=vFFG) >=$(=vFIG)'} ,
Gestion.CodigoCliente ={ 'CNA009002'}>, }Gestion.Qty)

That seems like it should be valid.

Wed, 25 Aug 2010 15:42:01 GMT

I put #s because vFFG and vFIG are variables, is not correct. I made the following correction and it works

SUM( {$<Gestion.FechaRegistro={"<=$(#vFFG) >=$(#vFIG)"} ,
 Gestion.CodigoCliente =
{'CNA009002','CNA009003'}>} Gestion.Qty )

Thanks for you answer.