Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Set Analysis: Max Date for Sales not Null

Hello,

I have the following expression with set analysis:

Sum( {<Type = {'North','South'}, Operation_Date = {"$(=Max(Operation_Date))"}>} >} Sales)

This is to get the Sum of Sales for the Max Operation_Date.

The issue with the expression is that the Max Operation_Date could have null values for Sales.

That's why I need to modify the Max(Operation_Date) to get the Max Operation_Date where Sales are not null.

Do you know how could I do that?

Thank you!

1 Solution

Accepted Solutions
sunny_talwar

Or this

Sum({<Type = {'North', 'South'}, Operation_Date = {"$(=Max({<Sales = {

  • }>} Operation_Date))"}>} Sales)
  • View solution in original post

    2 Replies
    MK9885
    Master II
    Master II

    Maybe

    Sum( {<Type = {'North','South'}, Sales = {'*'},Operation_Date = {"$(=Max(Operation_Date))"}>} >} Sales) ??

    sunny_talwar

    Or this

    Sum({<Type = {'North', 'South'}, Operation_Date = {"$(=Max({<Sales = {

  • }>} Operation_Date))"}>} Sales)