Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am using "Simple Filed Select" from extension available in QS. My value for the filter is as below.
Jan|Feb|Mar...........|Dec
I would like to Select multiple filter by default using expression under Appearance->Selections->"Select this one as default"
For example: I would like to select all the previous months including current month as default selection.
I am using this expression "=if(left(month(today()),3)='Oct','Jan|Feb|Mar|Apr|May|June|July|Aug|Sep|Oct','Jan')" But it is not selecting anything by default. It works fine with One selection but not Multiple.
Please some one help me to correct it.
Thanks,
Try to use '*' before and after every month. It worked in my app in a similar case.
You could create another column in the load editor in which you have 1 for current and past months and 0 for future months (example). Then you select this column as a filter and set it as a default bookmark.
So everytime you open this app you will have this filter selected.