Year filter

[TomBond77]

Hi experts

In our app we have a filter on Year.

Now we need in only one sheet of this app a modificated view of the table. Year should be derived from the field "Execution date" and not from the Year in the filter. How can we oversteer this behaviour of the "default" filter Year?

My formular looks like this, but is not working.

sum({<year($(=([Execution date] = [Year])))}>} [Count Order])

Many thanks

Tom

[chrismarlow]

Hi,

Building somewhat on this;

Solved: Using Year function in set analysis - Qlik Community - 1097956

Maybe try something like;

sum({<Year=,[Execution Date]={">=$(=date(floor(YearStart(makedate(Only([Year]),1,1)))))
<=$(=date(floor(YearEnd(makedate(Only([Year]),1,1)))))"}>}[Count Order])

Cheers,

Chris.