Displaying custom msg if there is a "Null Value"

[#1]

Hi Stefan,

I am re framing the question below.and have attached a new qvw file null.qvw

Based on the "Group" selection we need to check the "FINAL" field  whether it has any null values or not.If there is any one null value, We Need to Give a Message in a Textbox  as " Yes final has a Nullvalue" or else " No null values".If no selection in the Group field the Text should  display "Final field has null values or not" based on the same condition.

Let me know if i need to re frame the question.

Thanks and Regards,

Regards,

Pooja.

Message was edited by: pooja prabhu

[swuehl · Accepted solution]

What about

='Result: ' & If(NullCount(test),'contains NULL','no nulls')

[#3]

Hi Swuehi,

Thanks for your response. Your solution is correct but it's not my requirement.

Here i don't want to create a list box for the field "test". I wanted to display the result based on the straight table changes. Bcz If we are using the calculated column for "Test" field. It should work.

Thanks,

Pooja

[Anonymous]

Hi pooja:

You can write it on dimension or in load script

IF(IsNull(test),'Your Comment',test)

Regards

[sasiparupudi1]

=if(NullCount(test)=0,'No','Yes null value')

[susovan]

Hi Pooja,

Please check this attachment.

[swuehl]

Not sure if I understand your request. Did I created a list box for the field test? I don't think so.

I just modified the text box expression, and I believe it's pretty much what you asked for in the blue text box above your chart.

Regards,

Stefan

[Anonymous]

Change your dimension with this: IF(IsNull(test),'Your Comment',test)