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

[syedsaqib]

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:

[MayilVahanan · Accepted solution]

HI @syedsaqib 

Try with fabs() function