filter to load only data until current month

vikasshana — Fri, 01 Jul 2022 07:05:09 GMT

Hi,

I've a date filter in my app which has the dates from 2020 until 2022, I've created a year filter to see only the 2021 and 2022 years in list box using the below expression and is working as expected.

=aggr(only({<Year = {">=$(=year(today())-1)<=$(=year(today()))"}>}Year),Year)

Now my requirement is to create another filter for month and I would like to see data until current month, it means if I select 2021 in year filter I want month's from Jan - Dec and if I select 2022 in year filter I want month's from Jan - July (Current Month).

Regards,

Vikas

@sunny_talwar

topic filter to load only data until current month in QlikView

filter to load only data until current month