topic set analysis in QlikView

set analysis

Mon, 06 May 2013 20:00:24 GMT

Hi everyone;

I need to get the sum about all orders different with description 'ON HOLD' the dimention that have this description is called Delay_Days:

i was trying inside of a text-box-component but doesn't work this way:

= if(Delay_Days<> 'ON HOLD',Sum({$<ORDENES={'On Time'} >} NumberofLines),0)

OTHER WAY:

Sum (IF(Delay_Days<> 'ON HOLD',({$<ORDENES={'On Time'} >} NumberofLines),0)

BOTH WAYS doesn' t can you help please!!!!!

Mon, 06 May 2013 20:14:16 GMT

This may do it, but you'll need to qa the result to make sure it's working as expected:

sum({$<ORDENES={'On Time'} >} if(Delay_Days<> 'ON HOLD', NumberofLines))

Best,

Matt

Mon, 06 May 2013 21:14:46 GMT

thanks for your help but may be there are something wrong in my script because doesn't work ok anywhere thanks very much

Gysbert_Wassenaar — Tue, 07 May 2013 06:15:50 GMT

Try: Sum ({$<ORDENES={'On Time'},Delay_Days -= {'ON HOLD'} >} NumberofLines). The -= means unequal.

Tue, 07 May 2013 12:39:43 GMT

Ok I will try !!! thanks very much for your help!!!!