how to add the "all" select item in drop down list when use unique value

[Jianxiong Wang]

text area>>Edit>>inset property control>>select drop downlist>>select unque value in column>>select table name and column then generate drop down list and find no "all" in list

[David Boot-Olazabal]

Hi Jianxiong,

Natively, a drop-down list does not offer you this 'All' option. You can, however, get it in via a couple of tricks:

-https://community.spotfire.com/questions/it-possible-bring-all-option-drop-....

-https://community.spotfire.com/questions/how-have-all-option-document-prope....

-https://spotfired.blogspot.com/2015/08/change-none-from-drop-down-list.html.

Hope this fits in your dashboard.

Kind regards,

David Boot-Olazabal

[Jianxiong Wang]

Hi, David:

 

     Can you enclosed the detail example for this so, I still do not understand how to realize it base on 2nd link you provide information.

[David Boot-Olazabal]

Hi Jianxiong,

 

I do not have the script unfortunately. The idea of adding an exta row to the Data Table, and then trigger an iron python script, sounds doable.

 

However, you could also try to set up a drop down list property, based on expressions (depending on how many values you have of course). If you pass the selected values from the document property to your filter values (see here for more code snippets on that: https://community.spotfire.com/wiki/ironpython-scripting-tibco-spotfire).

 

Maybe that would work in your situation as well. 

 

kind regards,

 

David Boot-Olazabal