topic [Load Script] If Field A is 0 then Field B is 0 in QlikView

[Load Script] If Field A is 0 then Field B is 0

DestinedTale — Sat, 16 Nov 2024 04:40:39 GMT

Hi, I would like another field value to change to 0 based on the first field. Something like this

If amount due is less than 0 then field B will be 0 then with another if condition

if([A] < 0, [A]) as [B], second condition

MindaugasBacius — Thu, 24 Jan 2019 07:57:31 GMT

If([amount due] < 0, 0, If(A < 0, A, ':')) as B

This should do the job.

prieper — Thu, 24 Jan 2019 07:58:09 GMT

if([A] < 0, [A], second condition) as [B]
should do

nilaksh92 — Thu, 24 Jan 2019 19:44:46 GMT

I think the below syntax might work

load

if(A<0,0,if(A>0,Value/Field,DefaultValue)) as B

From xyz

Do let me know if this answers your query?