Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
venkatbza
Creator
Creator

How show only null values in a straight table

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

Dateproductlocationseller
1-1-2018bananaUSAxyz
2-1-2008appleindiaabc
3-1-2008mangoJapandef
banananepalhgf
bananachinakdj
mangoSingapornhg
applelondonygf

Thanks,

Venkat 

1 Solution

Accepted Solutions
gerry_hdm
Creator II
Creator II

Settig by the Load Statement

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

then you can selected only the Date values with NULL 

greetings Gerold

View solution in original post

2 Replies
gerry_hdm
Creator II
Creator II

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
Specialist III
Specialist III

hello

tou can try the nullasvalue function