Set analysis, disregard selection

Wed, 20 Aug 2014 15:05:47 GMT

Hi there,

I have a date selection in my UI. - it'a REF_DATE in my qv table

There is also a chart where I do sum(amount) in my expression.

I need another expression, which has logic

sum(if REF_DATE <= selected REF_DATE, amount, 0)

so, when I select 1 July 2014 i need to get accumulated amount until selected day.

I tried something like this, but it doesn't work. Somehow I need to eliminate current selection

=Sum({<REF_DATE={"<=$(= max(REF_DATE))"}>} amount)

Can you please help me

Thanks

Re: Set analysis, disregard selection

Wed, 20 Aug 2014 15:06:51 GMT

Can you try like this

=Sum({1<REF_DATE={"<=$(= max(REF_DATE))"}>} amount)