Incorrect sign in Difference/variance expression (with -ve denominator only)

syedsaqib — Sat, 16 Nov 2024 00:58:55 GMT

Hello Experts!

I like to know if there is any syntax in Qlik Sense which can be used to resolve incorrect Sign in Diff. % column.

I used Abs() in SAC cloud to resolve this, but don’t know if we have anything in Qliksense.

For example:

Period 1, % Difference should be +ve but it shows -ve % difference of -17.4%.

FYI, incorrect sign only shows up when PY value (denominator) has -ve Sign, otherwise, the formula works fine for all other combination as shown below from Period 4 to 12.

I have attached sample application and snapshot.

Thanks!

Here is the snapshot from sample qvf.

Here is snapshot from my my actual app:

Re: Incorrect sign in Difference/variance expression (with -ve denominator only)

MayilVahanan — Wed, 09 Dec 2020 02:39:40 GMT

HI @syedsaqib

Try with fabs() function

topic Incorrect sign in Difference/variance expression (with -ve denominator only) in App Development

Incorrect sign in Difference/variance expression (with -ve denominator only)

Re: Incorrect sign in Difference/variance expression (with -ve denominator only)