How to make one date filter that filters on 2 expressions with different years

[gorterzelf7]

Hello all,

I got a question which i hope somebody can help me with.

In attached QlikSense app i have three colomns.

Week

1 with data from 2018

1 with data from 2017

I want to make a filter that when i select a date for example 1 march, i see all revenue in both colums below 1 march.

Anybody got an idea how to fix that?

Regards Martijn

[gorterzelf7]

Anybody got an idea? Maybe petter-s‌? Who knows a lot;-)

[gorterzelf7]

Use daynumbers and you should be fine... if anybody is interested.

'{<Jaar={$(vJaar1)}, Week=,DagNummerVanJaar= {"<=$(vDagnummerVanJaar)"}>}',