QlikSense Button

[alanwong1178]

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],), ';'))'

[MayilVahanan]

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()

[jbhappysocks]

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()'