Help required in one Expression

[shiveshsingh]

Hello Guys

I need one help in below expression - 

(SUM({$<OrderDate={">=$(=DATE(MonthStart(MAX({$}OrderDate)),'DD/MM/YYYY'))<=$(=Date(MAX(OrderDate),'DD/MM/YYYY'))"}, FiscalMonth, Date,EXT_NEW_FLAG = {'N'}>} ABC))

Dimension - Day

Issue  - When i use EXT_NEW_FLAG = {'N'} in set expression, i get only those days which have this value. I don't get the days where the expression yields null.

like - If expression value is not present for 15 jan and 16 jan, these two days will not be shown in x axis

But when i remove EXT_NEW_FLAG = {'N'} in set expression, i get all the days of the current month whether expression gives value or is null.

Any leads?

[tresesco]

Here we are using IF instead of set analysis. Set analysis filters data before entering into the chart calculation whereas IF is context dependent, i.e.- performs in-chart calculation. That's why you can see the zero values using IF statement but in set analysis. Hope this helps.

[shiveshsingh]

Thanks @tresesco