Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
imoratal
Creator
Creator

PROBLEM URGENT-NEED REPLY

I have a month selected, for example September and I have a table with dates, for example 01/02/10 and 01/10/10.

I want to do a button that if i have push this button, in the table has to appear 01/10/10 because i have selected the September month and i want that in the table has dates>=selected month.

I don´t know how to do it with the graphics "button"

4 Replies
Not applicable

Use a Trigger, Select in Field. Field should be your date field. In the search string, something like:

='>=MakeDate(2010, $(=Only(Month)))'


You may need to convert the Month field to a number to work in the MakeDate() function. You can use Num for that. Plus, this will only select greater than the month in 2010, you may want to handle that year a little more dynamically.

It also helps to put some information about your question as your topic. That way people have an easier time identifying what kind of help you need.

imoratal
Creator
Creator
Author

I don't understand how I can do a trigguer

Not applicable

It's on the Actions tab of your Button properties.

You can also find more information in the Reference Manual. It's page 725 or 196 of Book II in the version I have under the heading Actions.

Miguel_Angel_Baeyens

Hi,

Besides using a dollar expansion if needed, syntax would look like

='>=$(=MakeDate(Year, Month))'


Regards