Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 

Removing Null Value Data Wile Loading as Load *

Hello Everyone,

Hope all of you are safe and in good health.

I would like to know that suppose I have a Data Sheet with 10 Fields (A, B, C, D, E, F, G, H, I, J) (Just an Example) and among those 10 fields suppose Field C & Field H have Null values So when I write the command

Load * , wanted to know the condition to be applied so that the Fields C & H are not loaded itself in the Data Load Editor (Qlik View).

Thanks in Advance.


Satish Rathod

Labels (2)
1 Reply


If you want to ignore the field, you can remove from the data model.

Ie. instead of *, mention the field names which need to load in the datamodel like below

Load A, B, D, E, F, G, I, J from urexcelsheet;


Thanks & Regards,
Mayil Vahanan R