Set analysis - ignore selection doesn't work

[joeallen]

Hello

I have a filter PreviousMonth which gives me the Date range 2019-02-01 to 2019-02-28

However I need to make an exception to ignore this in an expression in order to get the sum value for yesterday (2019-03-04), which is the same as max(Date) in my application

=sum({<PreviousMonth=,  Date={"$(=max(Date))"}>}value)

This doesn't work, anyone know why? I only get the value for 2019-02-28 with the above expression.

I cannot use {1} either as that ignores everything, i need to only ignore PreviousMonth. Any help would be appreciated

[agigliotti]

you got it because of max(Date), why did you use it?
what about using: sum( {< PreviousMonth >} value )

[pradosh_thakur]

Where do you use this , if you use this ina text box/kpi it shall give you the correct answer. If in a table you need to tell us what are the dimensions.

[joeallen]

it's in a textbox without dimensions, it doesn't work...

[mrybalko]

@joeallen 

Could you provide test qvw?

[joeallen]

@mrybalko 

here is sample provided

Just to reiterate:

I want the expression to ignore "PreviousMonth", when it's active, i.e. set to Yes.

So I want it to show the sum value for max(date), which is 2019-03-04, which is 8156185.05

But it shows the value for 2019-02-28, which is 9610818.95, even if i have PreviousMonth= in the expression.

[mrybalko · Accepted solution]

=sum({<PreviousMonth=,  Date={'$(=max({<PreviousMonth=>}Date))'}>}ValueEUR)

[joeallen]

thank you! i didnt know you had to write the ignore field inside the max function...