Do not show null values in table

[#1]

Hello,

I have a table in qlikview that has columns DAY, TOPIC, DISCUSSION.  I would like to have it so that if there is no value in the DISCUSSION field then it will not display the DAY and TOPIC fields that go along with it.  How would i go about doing this?

Thanks,

[#2]

Hi Brandon,

If these are dimensions then you have the option to suppression null values in the chart.

hope that helps

Joe

[yduval75]

In a straight table, you can put in your expressions

If(len(DISCUSSION) > 0, Only(DAY))

If(len(DISCUSSION) > 0, Only(TOPIC))

or put Day and Topic in dimension and Disucussion in expression with suppress null values in presentation tab.

[#4]

I'm having a hard time figuring this out.  I put in the above code...

If(len(DISCUSSION) > 0, Only(DAY))

If(len(DISCUSSION) > 0, Only(TOPIC))

in the general tab under calculated condition and nothing worked.  I also tried it under the sort tab and it didnt work.  Where is the expression supposed to go?  I also checked the omit rows where field is null under presentation and it doesnt hide the rows

[anbu1984]

Expression: If(len(DISCUSSION) > 0, Your_expression)