topic Re: Banding financial values in QlikView

Banding financial values

Tue, 17 Mar 2015 11:54:23 GMT

Hello everyone,

I've been working within an application to try and group some of our monthly financial values into bandings. The issue I'm having is our data for leavers is in minus figures and the script I've got seems to ignore any values that are minuses.

Does anyone know how I can do this? I want to be able to put the value -7500 in the band 5-10k.

I can't change the minus to a positive as we have balancing data that ends up double counting

Any ideas is appreciated.

Re: Banding financial values

Roop — Tue, 17 Mar 2015 11:59:04 GMT

It would be useful if you include the script.

You could just process the 2 differently with and IF... statement...

Pseudo code:

If(DateLeaving > DateEmployed,

Band5to10,

Band the data as normal .....

) as Banding,

Re: Banding financial values

rubenmarin — Tue, 17 Mar 2015 12:04:40 GMT

Hi Samuel, how you assigning bandings?

Maybe using fabs() when asigning the value to the banding can help. fabs() returns the absolute number, so it's always positive.