topic Re: Comparison when negative in QlikView

Comparison when negative

Wed, 16 Jul 2014 10:14:43 GMT

Hello everyone,

In my dashboard I use a flag to compare :

If(COST>INVOICED,1) as "Flag PRS > Amount Invoiced"

It works.

The problem is with negative value.

For example, I have a cost at -49€ and an invoiced at -147€.

It enter to my flag, while you would not.

Is it possible to avoid this ?

Thanks

alexandros17 — Wed, 16 Jul 2014 10:16:18 GMT

Try this:

If(Fabs(COST)>Fabs(INVOICED),1) as "Flag PRS > Amount Invoiced"

let me know

ashfaq_haseeb — Wed, 16 Jul 2014 10:19:18 GMT

Hi,

look at fabs function, It will help you.

Regards

ASHFAQ

Fri, 18 Jul 2014 07:38:48 GMT

Thanks, it works