topic Re: Fabs function dimension set analysis in QlikView

Fabs function dimension set analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

I need to create an expression based on a field like: SUM({<fabs(FIELD) = {'20'}>} VALUE). Thats is, I need to sum VALUE where the absolute value of FIELD is equal to 20 (so, the FIELD = 20 and FIELD = -20 will be considered in the SUM). However I couldn't find a way to do without creating a second field in the script using the FABS function (I want to avoid creating it).

Thanks!!

Re: Fabs function dimension set analysis

sunny_talwar — Wed, 18 May 2016 14:40:48 GMT

How about this?

Sum({<FIELD = {'20', '-20'}>} VALUE)

Sum({<FIELD = {"=fabs(FIELD) = 20"}>} VALUE)

Re: Fabs function dimension set analysis

Kushal_Chawda — Wed, 18 May 2016 14:46:01 GMT

Better to create the Flag in script

LOAD if(fabs(FIELD)=20,1) as Flag

....

FROM Table.qvd(qvd)

Now create the Expression

sum({<Flag={'1'}>} Value)

Replace QVD name with your actual QVD with Path

Re: Fabs function dimension set analysis

sunny_talwar — Wed, 18 May 2016 14:47:34 GMT

I think OP wants to avoid making changes to the script

Re: Fabs function dimension set analysis

Anonymous — Wed, 18 May 2016 14:48:03 GMT

try this

SUM({$<FIELD={'*20'}>} VALUE)

Re: Fabs function dimension set analysis

Kushal_Chawda — Wed, 18 May 2016 14:53:03 GMT

then you are correct