Hello, I have set up a dropdown in Blox that shows all states of the US. I can select a state and apply the filter across my dashboard and it works properly, but after I click apply, the VIEW of the dropdown menu always defaults back to showing the very first option instead of showing the option I selected. Any ideas how to resolve and show my selection instead? Thank you!

Hi JoshG , Try the script in this post: https://www.binextlevel.com/post/blox-drop-down-v2-without-apply-button https://www.binextlevel.com/post/blox-drop-down-with-all-selection -Hari

Dropdown Menu Blox Display Issue

2 Replies

Replies have been turned off for this discussion

Alek_qbeeq
Cloud Apps
03-02-2023
Hey JoshG

In order to show what is selected you need to add two things in blox editor:

1. some class name to dropdown, 'tester' for example,
2. add script which will find filter and set it on dropdown

"script": "var found = prism.activeDashboard.filters.$$items.find(element => element.jaql.title == 'YOUR FILTER TITLE'); var filterMember = found.jaql.filter.members[0];$('.tester').val(`${filterMember}`)",

Please note, that it has to be in one line.

If you're looking for something more advanced, please take a look at QBeeQ Advanced Filter plugin which is by far the best filtering solution available for Sisense. This plugin allows you to create advanced customized filters on the dashboard area itself, with many functional and design options.

Always here to help,
Alek from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner
www.qbeeq.io
harikm007
Data Warehouse
03-02-2023
Hi JoshG ,

Try the script in this post:

https://www.binextlevel.com/post/blox-drop-down-v2-without-apply-button

https://www.binextlevel.com/post/blox-drop-down-with-all-selection

-Hari

Forum Discussion

Dropdown Menu Blox Display Issue

2 Replies

Recent Discussions

Pivot Table widget - column headers and column data out of alignment

Blox conditional formatting up and down indicators

Remove Widget Title Box

Change Legend Category Names

Rename the Pivot Grand Total

Sisense

Support

Resources