topic Re: Drop field under condition in QlikView

Drop field under condition

pepe2209 — Mon, 16 Dec 2013 14:55:38 GMT

Hello,

I was wondering if it is possible to drop fields in the script if they fit certain conditions. See example:

So in this case I would like to drop field A3 because all values are 0.

something like:

IF(sum(A3)=0 THEN drop field A3 ENDIF

does not work.

Does anybody have an idea if this is possible? the goal is to limit the size of the document.

your help would be much appreciated.

regards

Peter

Anonymous — Mon, 16 Dec 2013 14:59:02 GMT

It is possible.

IF <condition> THEN

ELSE

END IF

In your case, you don't need the ELSE part

Nicole-Smith — Mon, 16 Dec 2013 15:01:07 GMT

Michael Solomovich is correct in his response. If seeing some working code will help you out more, here is an example:

data:

load * inline [

ID,A1,A2,A3

1,12,10,0

2,23,44,0

3,3,5,0

4,14,23,0

];

sums:

load sum(A3) as sumA3

resident data;

let vSumA3 = PEEK('sumA3');

if $(vSumA3) = 0 then

drop field A3;

endif

drop table sums;

pepe2209 — Mon, 16 Dec 2013 15:23:48 GMT

Yes this is exactly what i need.

Thanks to both of you!