Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gorterzelf7
New Contributor III

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

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

2 Replies
gorterzelf7
New Contributor III

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

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

gorterzelf7
New Contributor III

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

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

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