topic Set Analysis: Max Date for Sales not Null in QlikView

Set Analysis: Max Date for Sales not Null

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

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!

MK9885 — Fri, 06 Jul 2018 17:15:06 GMT

Maybe

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

sunny_talwar — Fri, 06 Jul 2018 17:18:31 GMT

Or this

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

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