topic how to eliminate all null values when saving in CSV in QlikView

how to eliminate all null values when saving in CSV

danny4202001 — Fri, 27 Jan 2023 17:03:32 GMT

Hello Friends,

How to write a script to save all fields in CSV except those that have zero values in the same row?

in the below case how to avoid Items 1,2 & 3 and all calculations are sum(if(statements

Thanks,

Vegar — Sat, 28 Jan 2023 07:30:29 GMT

You could try something like this.

ToStore:

NoConcatenate Load *

From/Resident Source

Where

MTDShipped <>0

AND CMTMOpen <> 0

etc...

;

Store ToStore Into MyCsv.csv (txt);

Drop table ToStore;