Set analysis question

[jduluc12]

HI,

I have an expression

=sum({<Date={">=YearStart(max(Date)))<=$(=max(Date))"}, Year=, Month=, >} Amount)

and i got filters for year and month and my expectation is if I select the year 2015 and month May then I should see the chart with only data from 01/01/2015 to 05/31/2015 but it even shows the data from Dec, 2014.

What am i missing here?

Thanks,

jean

[dsharmaqv]

can you please post oyur app

[jduluc12]

Hi Deepak,

It would be difficult for me to post app because it got a lot of sensitive data.

Can you figure out any issue by just looking at the expression? Shouldn't it work as i am expecting?

have i used Year=, Month=, correctly?

Thanks

[stabben23 · Accepted solution]

Hi,

I'll think you now only find this part "<=$(=max(Date)", try to add a $ and a = here:

sum({<Date={">=$(=YearStart(max(Date)))<=$(=max(Date))"}, Year=, Month=, >} Amount)

[Anonymous]

Have you tried without this part: Year=, Month=

=sum({<Date={">=YearStart(max(Date)))<=$(=max(Date))"}>} Amount)

Qv will ignore Year and month selections because of this Year=, Month=

[jduluc12]

ok...the $ sign was there and i had missed the "=" so it added but it still brings from 2014.

[flipside]

You have an extra closing bracket in the YearStart expression, I think.

[dsharmaqv]

try by removing this Year=, Month=,

[jduluc12]

Hey

it worked...i think the problem was missing "="..

Thank you

[jduluc12]

yes that was also a problem.

Thanks.