expression use

[#1]

hi

i am working on a qlik view document having list boxes store_id,store_desc,store_manager,store_name,store_id. i am trying to use an expression as

"                 

sum({<store_manager={'*a*}>}store_id)

what must be the outcome of this expression??

[jagan]

Hi,

This expression results the sum of store_id values, for those store_manager values having 'a'.

=sum({<store_manager={'*a*}>}store_id)

Hope this helps you.

Regards,

Jagan.

[v_iyyappan]

Hi,

     Outcome of above exprssion is if Store_Manager 'a' means it will sum of Store_id,

Please use Count instead of Sum because id not calculate the sum value.So use the expression like this

=Count({<store_manager={'*a*}>}store_id)

Regards,

Iyyappan