Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
harveenkaur
Contributor III
Contributor III

Null value in inline

How to assign NULL value (NOT Blank) in inline load to some value in row.Example:-

Load * inline [

 Product,Product_Group, Sales

A,,1000

B,b,2000

]

;

 

In the above case for A product, product group is blank but I want it to be null.

Labels (2)
1 Reply
tresesco
MVP
MVP

Add the below line before your load statement.

SET NullInterpret='';