Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Jayrus
Contributor
Contributor

Set Analysis (two expression)

Hello,

I'd like to create a measure with a set-expression that excludes data that is above a certain date and the date may not be NULL. I can't seem to figure is out.

The function is: Sum({$<[Datum betaald - Date]={">03-07-2018"}>}[Datum betaald - Date]-Factuurdatum)

I'd like to add exclude NULL values for the same field.

 

Thanks in advance

Labels (1)
1 Reply
lironbaram
Partner - Master III
Partner - Master III

hi 

when you use the higher than something in your set analysis you automatically also exclude the null values from the field