How show only null values in a straight table

[venkatbza]

Hi Friends,

I have a straight table in that there are four dimensions, in one dimension (Date) have some null values  I want show only that null values data with remaining columns fields. Please help me How it can be do.

for instance

Date	product	location	seller
1-1-2018	banana	USA	xyz
2-1-2008	apple	india	abc
3-1-2008	mango	Japan	def
	banana	nepal	hgf
	banana	china	kdj
	mango	Singapor	nhg
	apple	london	ygf

Thanks,

Venkat 

[gerry_hdm · Accepted solution]

Settig by the Load Statement

If ( isnull(Date),1,0) as Selecter

then you can selected only the Date values with NULL 

greetings Gerold

[olivierrobin]

hello

tou can try the nullasvalue function