topic Re: How to make one date filter that filters on 2 expressions with different years in App Development https://community.qlik.com/t5/App-Development/How-to-make-one-date-filter-that-filters-on-2-expressions-with/m-p/105410#M7159 <HTML><HEAD></HEAD><BODY><P>Anybody got an idea? Maybe <A href="https://community.qlik.com/qlik-users/146975">petter-s</A>‌? Who knows a lot;-)</P></BODY></HTML> Mon, 10 Sep 2018 12:56:09 GMT gorterzelf7 2018-09-10T12:56:09Z How to make one date filter that filters on 2 expressions with different years https://community.qlik.com/t5/App-Development/How-to-make-one-date-filter-that-filters-on-2-expressions-with/m-p/105409#M7158 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I got a question which i hope somebody can help me with.</P><P></P><P>In attached QlikSense app i have three colomns.</P><P></P><P>Week</P><P>1 with data from 2018</P><P>1 with data from 2017</P><P></P><P>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.</P><P></P><P>Anybody got an idea how to fix that?</P><P></P><P>Regards Martijn</P></BODY></HTML> Sat, 16 Nov 2024 07:42:06 GMT https://community.qlik.com/t5/App-Development/How-to-make-one-date-filter-that-filters-on-2-expressions-with/m-p/105409#M7158 gorterzelf7 2024-11-16T07:42:06Z Re: How to make one date filter that filters on 2 expressions with different years https://community.qlik.com/t5/App-Development/How-to-make-one-date-filter-that-filters-on-2-expressions-with/m-p/105410#M7159 <HTML><HEAD></HEAD><BODY><P>Anybody got an idea? Maybe <A href="https://community.qlik.com/qlik-users/146975">petter-s</A>‌? Who knows a lot;-)</P></BODY></HTML> Mon, 10 Sep 2018 12:56:09 GMT https://community.qlik.com/t5/App-Development/How-to-make-one-date-filter-that-filters-on-2-expressions-with/m-p/105410#M7159 gorterzelf7 2018-09-10T12:56:09Z Re: How to make one date filter that filters on 2 expressions with different years https://community.qlik.com/t5/App-Development/How-to-make-one-date-filter-that-filters-on-2-expressions-with/m-p/105411#M7160 <HTML><HEAD></HEAD><BODY><P>Use daynumbers and you should be fine... if anybody is interested. </P><P></P><P>'{&lt;Jaar={$(vJaar1)}, Week=,DagNummerVanJaar= {"&lt;=$(vDagnummerVanJaar)"}&gt;}',</P></BODY></HTML> Thu, 27 Sep 2018 14:57:40 GMT https://community.qlik.com/t5/App-Development/How-to-make-one-date-filter-that-filters-on-2-expressions-with/m-p/105411#M7160 gorterzelf7 2018-09-27T14:57:40Z