topic Condition in QlikView

Condition

dseelam — Tue, 21 Mar 2017 14:57:09 GMT

Hello All,

Attached files has item types with Demand and ONHAND, I am trying to get active, slow moving and obsolete item types

I need

sum(if(DMND>0,(DMND>ON_HAND),ON_HAND)) //////////active

sum(if(DMND<>0,(ON_HAND>-DMND),HAND)) ////////////////////slow

sum(if(DMND=0,ON_HAND>DMND,ON_HAND)) //////////////////////obs

but where ever ONHAND is '0'its giving me -1 which is wrong is there any other way to do it ?

Thanks,

Re: Condition

Anil_Babu_Samineni — Tue, 21 Mar 2017 15:25:20 GMT

May be this?

If(DMND > ON_HAND, Sum(ON_HAND))

Re: Condition

dseelam — Tue, 21 Mar 2017 15:51:13 GMT

Thanks anil

How to include other condition DMND should be always >0

Re: Condition

Anil_Babu_Samineni — Tue, 21 Mar 2017 16:09:48 GMT

This condition should work

If(DMND > ON_HAND and DMND >0 and DMND <>0 , If(ON_HAND>DMND,Sum(ON_HAND)))

From your data, you may don;t have ON_HAND values > DMND Values. For this you can check. Whether you have value or it showing all "There are no Exceed"

If(DMND > ON_HAND and DMND >0 and DMND <>0 , If(ON_HAND>DMND,Sum(ON_HAND),'There are no Exceed'))