How to show only null values - straight table

[#1]

I have a straight table and I wan't to filter the table so that only the null values for the field 'Maturity Date' are shown. I wan't to do this as some sort of calculation or expression rather then using the load script or a button. Any ideas?

TIA

[sunny_talwar · Accepted solution]

May be a calculated Dimension:

If(Len(Trim([Maturity Date])) = 0, 'Null', Null())

[Anonymous]

Apply set analysis with

{$<Maturity Date-={*}>} in the expression

[effinty2112]

Hi Ben,

                    If you have an ID field in your fact table try this as a calculated dimension:

=Aggr(Alt([Maturity Date],'Null'),ID)

If you pick 'Null' in this calculated dimension Qlikview will select the IDs for which there is no Maturity Date.

good luck

Andrew