Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.