Hi All,
I created a button to with 2 actions . My idea is to clear all selections on ORDER_DATE Field from user first. Then system apply selection on ORDER_DATE field to show date smaller than today() as below.
1) Clear selections in field
2) select values in a field
From my understand , I expect that when I click the button , it performs all 2 actions . But I found out than when I made 1st click , it only clear selections . I need to made 2nd click in order to perform "select values in a field". This is a bug or is this the original design of the button function which it can only perform one action at one click.?
= '$(= concat( distinct if([ORDER_DATE.autoCalendar.Date]<today(),[ORDER_DATE.autoCalendar.Date],), ';'))'
HI
it will do both the action at a same time. I think, you want to select Order_date less than today. In that case, try like below
='<='&Today()
Hi
From help.qlik.com:
So instead of using Select values in a field, where Date is not possible, use Select values matching search criteria and use ='=[ORDER_DATE.autoCalendar.Date]<today()'
