Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Creator III
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.