topic Re: Dynamic Last 6 months in List box in QlikView

Dynamic Last 6 months in List box

pinky1234 — Mon, 26 Jan 2026 21:26:37 GMT

Hi,

I have month year field like this Jan-2021,Feb-2021,Mar-2021,Apr-2021...etc. So I wanted to show dynamically last 6 months in list box. For ex: On Aug 1st 2021 my list box should show Feb-2021,Mar-2021,Apr-2021,May-2021,June-2021,July-2021. Can some one help me on this? Thanks!

Re: Dynamic Last 6 months in List box

Kushal_Chawda — Thu, 22 Jul 2021 14:50:43 GMT

@pinky1234 if your month field is in Numeric format, you can try below in listbox expression. Otherwise, you first need to convert your month field in Numeric format using Date#

= aggr(only({<Month = {">=$(=date(addmonths(max(Month),-5),'MMM-YYYY'))<=$(=date(max(Month),'MMM-YYYY'))"}>}Month),Month)

Re: Dynamic Last 6 months in List box

pinky1234 — Thu, 22 Jul 2021 16:25:42 GMT

It is not working for me. I have field like this MonthYear and format is Jan-2021,Feb-2021,Mar-2021..etc.

I am trying to use like this formula: = aggr(only({<MonthYear = {">=$(=date(addmonths(max(MonthYear),-5),'MMM-YYYY'))<=$(=date(max(MonthYear),'MMM-YYYY'))"}>}MonthYear),MonthYear) But resulting Aug-2022,Sep-2022,Oct-2022,Nov-2022,Dec-2022,Jan-2023. But i need it last 5 months in 2021.

Re: Dynamic Last 6 months in List box

pinky1234 — Thu, 22 Jul 2021 16:29:22 GMT

Last 5 months in 2021 means from Feb-2021 to July-2021.

Re: Dynamic Last 6 months in List box

Kushal_Chawda — Thu, 22 Jul 2021 23:46:47 GMT

@pinky1234 try below

aggr(only({<MonthYear = {">=$(=date(addmonths(today(1),-5),'MMM-YYYY'))<=$(=date(today(1),'MMM-YYYY'))"}>}MonthYear),MonthYear)