Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danny4202001
Contributor II
Contributor II

how to eliminate all null values when saving in CSV

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

danny4202001_0-1674838926018.png

 

Thanks,

D

 

 

1 Reply
Vegar
MVP
MVP

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;