Discussion board where members can get started with Qlik Sense.
I have a straight table with two columns: A and B with the following values.
I want to show only those values of column A which have only NULL values of Column B.
For e.g., for column A =60 and 63, Column B is NULL and NON-NULL. So, in this case I want to show all values of Column A except 60 and 63.
you can use filter on the column A '=isnull(B)' as radoresky mentioned in one of his posts .
I want to show only those values in the table which are only NULL.
I don't want to show the NON NULL values.
May be a calculated Dimension:
If(Len(Trim([YourField])) = 0, 'Null', Null())
Add Calculation Dimension for Column B like below.