Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be a calculated Dimension:
If(Len(Trim([Maturity Date])) = 0, 'Null', Null())
May be a calculated Dimension:
If(Len(Trim([Maturity Date])) = 0, 'Null', Null())
Apply set analysis with
{$<Maturity Date-={*}>} in the expression
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