topic Re: Calculated field in the script in QlikView

Calculated field in the script

Anonymous — Tue, 16 Jan 2018 22:36:16 GMT

I am trying to create a calculated field in the script , based on utilization ,

here is the logic

load

if("SPR_Quantity" > Counter and Counter <> 0 AND Counter >0 ,'Under',

if("SPR_Quantity" = Counter,'None',

if("SPR_Quantity" < Counter or Counter < 0 ,'Over',

if(Counter = 0 ,'All Used')

))) as Usage

I am able put the same logic in the chart but not in the script , I don't see "Over" SPR being filtered out correctly , can someone tell me why ?

Thanks

Anonymous — Tue, 16 Jan 2018 22:36:57 GMT

Attached my document

swuehl — Tue, 16 Jan 2018 22:57:47 GMT

Aren't you using the SPR.SPR_SUM_QTY field instead of the SPR.SPR_QUANTITY field in your chart expression?

Anonymous — Tue, 16 Jan 2018 23:17:49 GMT

oops !! you are right SPR.SPR_Quantity is the field I have to use.