Getting details on demand button is quite straightforward in Spotfire, it comes as an inbuilt functionality. But what if you want to toggle it on and off, i.e. to show and hide by clicking on same button? That’s possible via Iron Python scripting.

Lets explore both the methods.

Learn Tibco Spotfire. One of the best BI tools used Industry wide that is also a part of Gartner’s Magic Quadrant ! Click here for a complete course at the Cheapest price !

Getting Details on Demand window by using Spotfire functionality

Lets say you have a bar chart (or any viz) as below. You are supposed to have a button that on clicking, displays the details on demand at the bottom of the page.

1.JPG

Steps –

  1. Insert a text area above.
  2. Right click – Edit HTML
  3. Click the ‘Insert Action Control’, 5th button from left in the toolbar.
  4. Give a display text, like – Details on Demand
  5. Let the Control type be ‘Button’
  6. Under ‘Available Actions’, expand the ‘Functions’ tree by clicking on + sign (See image below).
  7. Under that, expand the ‘View’ tree by clicking on + sign again.
  8. Here you see ‘Details on Demand’. Select it, and click ‘Add’.
  9. Click ‘OK’, close the HTML window.
  10. You have your Details on Demand button as needed.

Select some data, and hit ‘Details on Demand’ button. The window will pop on right/bottom of screen and can be moved around as comfortable.

2.JPG

Toggling Details on Demand window by using Scripting

Steps –

  1. Insert a text area above.
  2. Right click – Edit HTML
  3. Click the ‘Insert Action Control’, 5th button from left in the toolbar.
  4. Give a display text, like – Details on Demand
  5. Let the Control type be ‘Button’
  6. Now click the ‘Script’ button on the left panel, and click ‘New’ from right.
  7. Give your script a descriptive name like Toggle- Details on Demand.
  8. Enter the script as shown in image. Click OK, click OK again, and close the HTML window. Script is given at the last.
  9. Now select some data and hit the button. Details on Demand panel appears. Hit it again and it disappears.
  10. You now have a toggle button for showing / hiding the Details on Demand panel.
if (Document.ActivePageReference.DetailsOnDemandPanel.Visible == False):  
Document.ActivePageReference.DetailsOnDemandPanel.Visible = True else:  
Document.ActivePageReference.DetailsOnDemandPanel.Visible = False

19 thoughts on “Spotfire – Toggle Details on Demand visibility via script

  1. What’s up, I log on to your blog on a regular basis.
    Your story-telling style is awesome, keep it up! I visited several web sites but the audio feature for audio songs present at this website is in fact marvelous.
    I will right away seize your rss feed as I can’t in finding your e-mail subscription link or
    newsletter service. Do you have any? Kindly permit me know in order
    that I may just subscribe. Thanks. http://samsung.com

  2. Hi there I am so delighted I found your blog page, I
    really found you by error, while I was looking on Askjeeve for something else, Regardless
    I am here now and would just like to say many thanks
    for a incredible post and a all round exciting blog
    (I also love the theme/design), I don’t have time to look over it all at the moment but
    I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read a great
    deal more, Please do keep up the great work.

  3. Its like you learn my thoughts! You seem to know a lot
    approximately this, such as you wrote the e book in it or something.
    I feel that you simply could do with some p.c.
    to force the message house a little bit, however other than that, that is fantastic
    blog. A great read. I’ll definitely be back.

  4. I don’t even know the way I ended up here, but I believed this submit used to be great. I do not know who you are however definitely you’re going to a famous blogger should you are not already 😉 Cheers!

  5. I believe that is among the such a lot vital information for me.
    And i am satisfied studying your article. But wanna remark
    on few normal issues, The website taste is perfect, the articles
    is in reality excellent : D. Good activity, cheers

  6. Woah! I’m really digging the template/theme of this site.
    It’s simple, yet effective. A lot of times it’s hard to get that “perfect balance” between usability and visual appearance.
    I must say you have done a great job with this. In addition, the blog loads super fast for me on Safari.

    Excellent Blog!

Leave a Reply

Your email address will not be published. Required fields are marked *