Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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