topic Re: How to show only null values - straight table in QlikView

How to show only null values - straight table

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to show only null values - straight table

sunny_talwar — Thu, 08 Sep 2016 15:37:21 GMT

May be a calculated Dimension:

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

Re: How to show only null values - straight table

Anonymous — Thu, 08 Sep 2016 15:40:30 GMT

Apply set analysis with

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

Re: How to show only null values - straight table

effinty2112 — Thu, 08 Sep 2016 15:54:32 GMT

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