Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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?

4 Replies
Highlighted
MVP
MVP

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.

Highlighted
Partner
Partner

try this:

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

Highlighted
Partner
Partner

hope u'll answer this time... Fabio

Highlighted
Specialist III
Specialist III

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).


See: https://help.qlik.com/en-US/sense-cloud/Subsystems/CloudHub/Content/Scripting/LogicalFunctions/logic...

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago