Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
joeallen
Contributor III
Contributor III

Set analysis - ignore selection doesn't work

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

1 Solution

Accepted Solutions
mrybalko
Creator II
Creator II

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

View solution in original post

7 Replies
agigliotti
Partner - Champion
Partner - Champion

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

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.

 

Learning never stops.
joeallen
Contributor III
Contributor III
Author

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

@joeallen 

Could you provide test qvw?

joeallen
Contributor III
Contributor III
Author

@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
Creator II
Creator II

=sum({<PreviousMonth=,  Date={'$(=max({<PreviousMonth=>}Date))'}>}ValueEUR)
joeallen
Contributor III
Contributor III
Author

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