Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

how to write not null in the set analysis

Hi All,

I have a requirement where in i have to add a condition like resolveddate is not null. Can someone help me how to implement this condition in the set analysis ASAP.

Thanks in advance,

Smitha


2 Replies
Not applicable

Re: how to write not null in the set analysis

Just say resolvedate = {"*"}

Re: how to write not null in the set analysis

Hi

Filtering Null is a tricky part.

You can try {*} to select all values that should exclude the null value and - {''} should get rid of the blank values.

=sum({$<resolveddate ={'*'}-{''}>} 1)

Regards

ASHFAQ