topic expression use in QlikView

expression use

Mon, 27 Feb 2012 05:33:18 GMT

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 — Mon, 27 Feb 2012 05:36:57 GMT

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 — Mon, 27 Feb 2012 05:37:58 GMT

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