topic Re: How show only null values in a straight table in QlikView

How show only null values in a straight table

venkatbza — Thu, 05 Apr 2018 04:43:10 GMT

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

Re: How show only null values in a straight table

gerry_hdm — Thu, 05 Apr 2018 04:46:55 GMT

Settig by the Load Statement

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

then you can selected only the Date values with NULL

greetings Gerold

Re: How show only null values in a straight table

olivierrobin — Thu, 05 Apr 2018 09:46:54 GMT

hello

tou can try the nullasvalue function