Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Galaxy98
Contributor
Contributor

How to create a date drop box that displays yyyy-mm till three months ago

The current date dropdown is developed using a multibox that displays year month(yyyymm) till current month.

Now the current requirement of the client is to make changes in the expression, such that it displays date till 3 months ago as there is a 3 month delay in the data load.

current application : 

It is displaying date till last month like below, but now it should display from 202112( 3months ago)

Sneha98_0-1651044736273.png

 

 

1 Reply
pooja_prabhu_n
Creator III
Creator III

Hi,

Create last 3 month date column in script and use that in the multibox

if (monthstart(ReoportPeriod) > monthstart(addmonths(Today(),-3)), Date(MonthStart(ReoportPeriod),'YYYYMM')) as last3months,