topic Inconsistent behavior in in-table calculations in QlikView

Inconsistent behavior in in-table calculations

nenadvukovic — Mon, 04 Sep 2017 09:26:54 GMT

Hello,

Does anyone have an idea of why would this expression results with different results?

if("Balance" - "Safety Stock" < "Safety Stock", "Balance" - "Safety Stock", 0)

Items marked in yellow are expected to show 0 in the last column:

Thanks

Re: Inconsistent behavior in in-table calculations

Anil_Babu_Samineni — Mon, 04 Sep 2017 09:32:11 GMT

Try this?

if(("Balance" - "Safety Stock") < "Safety Stock", ("Balance" - "Safety Stock"), 0)

Re: Inconsistent behavior in in-table calculations

its_anandrjs — Mon, 04 Sep 2017 09:38:24 GMT

You have to write this

if("Balance" - "Safety Stock" < "Safety Stock", 0, "Balance" - "Safety Stock")

Re: Inconsistent behavior in in-table calculations

nenadvukovic — Mon, 04 Sep 2017 09:39:08 GMT

Thx, but I tried that before posting the question. Just one detail, those are not field names but column labels.

Re: Inconsistent behavior in in-table calculations

nenadvukovic — Mon, 04 Sep 2017 09:42:47 GMT

No, that does not work. I want to show red lines with actual numbers, and others with 0. If you look my screenshot you would see that lines 1 and 2 are fine, but lines 4, 7, 8, 10 are not. How come?

Re: Inconsistent behavior in in-table calculations

Anil_Babu_Samineni — Mon, 04 Sep 2017 09:53:18 GMT

Can you attach inline because i just tested and it's working.. I am not sure Where you made mistake. Are you doing this in script / UI ??

If UI, Try this? May be

if((Balance - [Safety Stock]) < [Safety Stock], (Balance - [Safety Stock]), 0)

This should work as i feel, But if number format issue, You could define Num() .. over expression

Re: Inconsistent behavior in in-table calculations

its_anandrjs — Mon, 04 Sep 2017 09:53:31 GMT

For 4th row values after your condition

1. Step

"Balance" - "Safety Stock"

38168 - 27000 = 11168

2. Step

"Balance" - "Safety Stock" < "Safety Stock"

11168 < 27000

This statement is true so for this true part of the statement execute

That is "Balance" - "Safety Stock"

Then why you expecting 0 let me know.

Re: Inconsistent behavior in in-table calculations

nenadvukovic — Mon, 04 Sep 2017 10:12:31 GMT

I apologize, it is consistent with the expression used. My mistake.

Thanks for your time. I'll mark all your replies helpful.