Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
I have the following button function that works in QlikView but doesn't produce a selection in QlikSense. It is giving me the "Previous 12 Full Months" of invoice data. So if clicked today, 2022-03-22, it would choose March 1, 2021 through Feb 28, 2022.
='>=' & Concat(Date(MonthStart(AddMonths(Today(), -12))), '<=', Date(MonthEnd(AddMonths(Today(), -1))))
I have reached out to a support group that gave me the below. It creates a selection, but it is ignoring the <= last day of last month. So I'm getting a selection of >= March 1, 2021.
=Concat({<[Invoice Date]= {">=$(=date(monthStart(addmonths(Today(),-12)))) <=date(MonthEnd(addmonths(Today(),-1)))"}>} DISTINCT date([Invoice Date]), ';' )
Would someone please offer some help? Below are my settings for the button.
My apologies. The first formula should have the "Concat". It's strictly using the & operator.