Grouping dates

[Ericus]

So I'm very new to Qlik, but I have two sets of dates in my table DateFrom and DateTo how can I filter my table with information that originates only in a certain month?

[Or]

What do you mean by "Originates only in a certain month"? If you mean anything that started in a certain month, you would typically add a Month field e.g. MonthName(DateFrom) and filter on that.

[Ericus]

Overall I'd like to view data with DateFrom and DateTo within a certain month, but I'd like to create a filter in my table so that another person could just change the filter and view all the data which have a DateTo and a DateFrom in a certain month.

[Or · Accepted solution]

If you need both DateTo and DateFrom to be within the same month, you'd want something like:

If(Monthname(DateTo) = MonthName(DateFrom),Monthname(DateTo))

In this scenario selecting a month, e.g. January 2021, will only select lines which both start and end in January.