Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
RC_121985
Contributor III
Contributor III

Simple Field Select

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,

 

Labels (1)
2 Replies
w0jt4z
Contributor III
Contributor III

Try to use '*' before and after every month. It worked in my app in a similar case.

Gui_Approbato
Partner - Creator III
Partner - Creator III

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.