want to show data for only blank values in straight table

[#1]

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

[Anil_Babu_Samineni]

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.

[prma7799]

in the Dimension tab

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

Or please share a sample data

[devarasu07]

Hi,

In your ID dimension use below expression

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

enable check box to suppress null values

[Anonymous]

Hi,

May be this will help you

If(isnull(date3),Body_No)

add this in expression

Thanks

Paridhi

[ahaahaaha]

Hi,

example in attached file.

Regards,

Andrey

[#7]

Thanks Andrey its working thanks lot