Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
cranium144
Creator
Creator

Button Function Works in View but Not Sense

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.

cranium144_0-1647883841368.png

 

Labels (1)
1 Reply
cranium144
Creator
Creator
Author

My apologies.  The first formula should have the "Concat".  It's strictly using the & operator.