4 Replies Latest reply: Jan 22, 2018 12:10 PM by Thiago Justen Teixeira

# agg value from a to z

Hi Community,

i need to sum all values

Excluding all alphabetic values and including only all numeric

To include all values ... my idea is to use *A-Z

To include only numeric.... my idea is to use -=

So that,

sum({\$<Commessa-={"*A-Z"}>}TotOreLavorate)

but it doesn't work.

Could you help me?

• ###### Re: agg value from a to z

Qlik Sense will only sum numeric values anyway so there is no reason excluding them. Even the average function Avg works correctly.

If you need to count only numeric values you have a special function for that named NumericCount.

• ###### Re: agg value from a to z

try this:

Sum({<Commessa={"=IsNum(Commessa)=-1"}>}TotOreLavorate)

• ###### Re: agg value from a to z

hope u'll answer this time... Fabio

• ###### Re: agg value from a to z

Fabio,

If you are not confortable to use NumericCount, maybe you should try a conditional sum.

Sum(If(IsNum(YOUR_FIELD)=-1,YOUR_FIELD))

Returns -1 (True) if the expression can be interpreted as a number, otherwise 0 (False).

Cheers