Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum Expression

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

=

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

Thanks





2 Replies
Not applicable
Author

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.

Not applicable
Author

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.