Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set analysis, disregard selection

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

1 Solution

Accepted Solutions
Not applicable

Re: Set analysis, disregard selection

Can you try like this

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

1 Reply
Not applicable

Re: Set analysis, disregard selection

Can you try like this

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

Community Browser