Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

want to show data for only blank values in straight table

Hi friends,

I want to show only those fileds which does not contain any date,
in the image column of date3 is blank but date 1 and date 2 having some dates in columns so i want to shows data if column of date 3 is blank in straight table

thanks

6 Replies
Highlighted

Would you share sample qvw, The expression you made you need to take only Null values in set operator then Please un-check the Supress when value in null.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Master III
Master III

in the Dimension tab

if(len(trim(date3))>0,null())

Or please share a sample data

Highlighted
Master II
Master II

Hi,

In your ID dimension use below expression

=if(len(Date3)=0,ID,0)

enable check box to suppress null values

Null1.png

Highlighted
Creator
Creator

Hi,

May be this will help you

If(isnull(date3),Body_No)

add this in expression

Thanks

Paridhi

Highlighted
Master
Master

Hi,

example in attached file.

Regards,

Andrey

Highlighted
Not applicable

Thanks Andrey its working thanks lot