The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
Hiding and Showing Data in a Visualization - Tip of the Week

Tip of the Week

Hiding and Showing Data in a Visualization

Many times when dealing with large datasets, users have a need to filter to relevant data within a specific visualization. However, they want to do it in a way that the full data set is still used to ensure correct expressions and calculations are applied.  For example, in a Bar Chart, users may only want to see the top 5 and bottom 5, but not all the ones in the middle. This can be accomplished in 5.5 using the ’Show-Hide Items’ option within a visualization.

If you look at the Bar Chart below there are lots of categorical values on the Category Axis and it makes it hard to interpret.

Hide Show 

What if you did not care about how a specific category compared to all others, but you just wanted to see how a specific category compared to the top and bottom 5 in that grouping?

With Spotfire 5.5, you have the option to add rules to hide and show data. This is available from the ’Show/Hide Items’ option on the Visualization’s Properties dialog.

Hide Show 2 

By clicking on the ‘Add’ button from within the Show/Hide Items option, you can add in rules similar to the Conditional Coloring rules.  When defining a rule, you can specify whether the rule will be used to hide items or show items. For this specific example, we can add a rule that shows we will show the top 5 values for the ‘Sum(Sales)’ expression.

We can then add another rule which says to show the bottom 5 values for Sum(Sales). 

Next we can add an ‘Equal to’ rule and then set the value either as a hard coded value or as an expression and set it to the name of the specific value in the category column. In this case we are analyzing sales across various product categories from the ‘Product Category 3’ column so we use the following expression: First([Product Category 3]). We can hard code one specific product category, ie ‘METAL BOOKCASES’

Hide Show 3 

NOTE: If adding the value using the ‘Value’ option, you don’t need to add quotes around your string. If you add it via the Expression option, you do need to add quotes.

 Hide Show 4

Our Bar Chart should now show the top 5 and bottom 5 values as well as a bar for our specific category METAL BOOKCASES.

Hide Show 5 

Then we can go into the Color axis and add an expression that will color the specific value we just added (METAL BOOKCASES) differently than the others so it is called out (NOTE we could have also done this by adding in a coloring rule)

Hide Show 6 

To take this example even further, using Property Controls, we can add a Drop Down Control that allows the user to select a value from the Property Category Column.  We can then use this to dynamically update the show/hide rule and color expression. This will allow the user to select a specific value, and display and color that value compared to the top 5 and bottom 5 in the Bar Chart.

 Hide Show 7

In addition, another nice enhancement in 5.5 is the ability to use Properties inside a visualization title. Now we can update the Drop Down Control to select a product category and have the title dynamically reflect this.

Hide Show 8


Hide Show 9 



Bliss said:

I and also my pals appeared to be checking out the good answers located

on your web page while immediately got a horrible suspicion I had not expressed respect to you

for those techniques. My guys ended up for the reason

stimulated to see them and have in effect certainly been taking advantage of them.

Thanks for genuinely considerably kind and also for getting such extraordinary information

millions of individuals are really wanting to be informed on.

My sincere apologies for not saying thanks to you earlier.

June 29, 2013 12:30 PM

Latizzle said:

Hmmn. Gonna try it out and get back to you.

July 1, 2013 11:50 AM

Crist said:

Horoscope de la vie signification sagittaire

July 7, 2013 1:19 AM

Mack said:

Formation transport logistique format string java

July 15, 2013 4:48 AM

minneapolis web said:

Hmm, let me give it a short try to see if it works out for me.

July 19, 2013 8:21 AM

Shelley said:

Wire connections tend to be unquestionably usually the debris, consequently purchasing disguising methods for

example glue could be vital if you need a professional and

clean glimpse. Having one of these software would reduce mistakes around

building your home. The telly is located powering any painting them or perhaps an artwork, that can

raise by the use of your swap or switch. It'll be wise to spend some time to believe on which matches in which? For instance the place are you looking your own patio's and where to place your

trashcans? You would possibly consider utilizing lawn containers and keep

elements neat and also pathways to prevent the idea clean up.

It requires many of the make a choice will get through the folks who,

to begin with, ruined this. Continually require specialized

viewpoints and recommendations any time necessary. A number

of shadings regarding daring red colorization by using white and black can give your home a classy and cool search.

These around totality, Mother earth requires one to assistance on an apparently difficult

quest for a far more less dangerous, enviroment friendly, in addition to a a lot more tranquil world.

July 24, 2013 7:02 AM

Embry said:

I have been reading out plenty of of your articles and i must say pretty first-rate stuff.

I will surely bookmark your site

July 25, 2013 7:03 AM

Oldham said:

Today horoscope horoscope yahoo elle

August 7, 2013 1:27 AM

Alley said:

Awesome site you have here but I was curious about if you knew of any discussion boards that cover the same topics discussed in this article?

I'd really like to be a part of community where I can get opinions from other experienced people that share the same interest. If you have any suggestions, please let me know. Thanks a lot!

August 9, 2013 10:32 AM

Les Gold said:

Thank you for the clear and well-informative info.

August 10, 2013 6:10 PM

Mahoney said:

Some actually choice content on this internet site

, saved to favorites .

August 13, 2013 3:54 AM

Mcintosh said:

Signification signes astrologiques l horoscope d aujourd ***

August 17, 2013 9:58 AM

Balderas said:

Cours d astrologie chat voyance gratuite immediate

August 18, 2013 12:33 AM

Bird said:

Savoir son signe astrologique chinois radioscoop horoscope

August 21, 2013 5:18 AM

Webber said:

Horoscop nostalgie les signes astrologiques dates

August 21, 2013 6:57 AM

Livingston said:

Sex club porne 2011

August 23, 2013 9:44 AM

Taggart said:

Horoscope mensuel gratuit 2012 ton tarot divinatoire

August 28, 2013 12:20 AM

Banuelos said:

Yahou horoscope reponse oui non gratuit

August 28, 2013 2:20 PM

Worsham said:

Dessins signes astrologiques horosco pe

August 28, 2013 4:43 PM

Scoggins said:

Tirage carte en ligne *** pisces weekly horoscope

August 30, 2013 4:45 AM

Rider said:

Direct voyance orgasm tarot divinatoire de marseille gratuit

August 31, 2013 4:30 PM

WritersBeware said:

WritersBeware Sep 25, 07, 10:40PM | #16

is an invalid domain, but  is another fraudulent outfit from Eastern Europe.

ScamIsLikeSpam Oct 10, 07, 10:05AM | #17

I paid $252 for their scam writing service. Their site promised that a native English speaker or someone with a mastery of the English language. However, when I previewed the written paper, there were several instances of incoherency and grammatical mistakes. Worse was the usage of parentheses and BOLD, or capital, letters, when the format I had requested, Turabian, made those anathema to utilize. Also, I had given specific quotes I wished to have used. Only one of these were given creedance. Secondly, I purchased their services with the "guarantee" of having a Junior or Senior college level work. For the reasons mentioned above, I would not have used this paper even in a Middle School context! It was that bad. Furthermore, the writer quoted, without citation, an article from Wikipedia, in which plagiarism is very suspect. Even if they had included the article in their citation, the Turabian style does not allow for the use of Encyclopedias as a proper source in such a paper. When I brought all of these things up to the writer and the administration, they were not concerned in the least. They told me that even if the quotes were plagiarized, they could not refund my whole amount. Yet, they claim that their service will stand up against plagiarizing software and that they do not tolerate plagiarism. I could have written the same thing for free. They also said, flippantly, that I should have re-worked their paper. However, I paid top dollar for a finished, polished paper, not a source to glean from.

By the way, and are run by the same scammers. Beware!!!

ScamIsLikeSpam Oct 10, 07, 10:23AM | #18

Also, it's interesting how they want you to send them YOUR paper to prove that theirs was inferior. I suspect that by doing so, either 1) your paper will turn up as being plagiarized by or they keep it on file for one of their "expert writers" to finagle with later.

Man, if I had known that these people got so much money for such crapy work, I would have started my own freelance writing company! Anyone want to join me in such an endeavor? We'd be rich! And imagine if we actually produced quality work. Amazing!

Lavinia Oct 10, 07, 03:01PM | #19

Quoting: ScamIsLikeSpam

Also, it's interesting how they want you to send them YOUR paper to prove that theirs was inferior. I suspect that by doing so, either 1) your paper will turn up as being plagiarized by or they keep it on file for one of their "expert writers" to finagle with later.

good point. i can't conceive of any legit reason a company would ask you to produce a paper to demonstrate the poor quality of theirs.

WritersBeware Oct 10, 07, 03:39PM | #20

I am no longer surprised by ANY of the new scams that these African companies employ.

essayer Oct 10, 07, 07:37PM | #21

i don't think a 100% refund is really possible. i read somewhere here that for every order or transaction initiated, some fees are automtically paid to the credit card company or something.

one lesson for anyone planning to use academic assistance sites is to ensure that all terms of service are agreeable to him or her.

wooly Oct 26, 07, 10:18PM | #22

I can relate complety to Muhammad's situation with . I paid for a paper that I was to use in a speech and it was absolutely horrible quality. The grammer was attrocious and some of the sentences didn't even make sense...the writer used synonyms that just didn't fit. I could have probably fixed those problems (not that I should have to) but what was worse was that the paper didn't even stay on topic! I asked for a paper on a specific person in medicine and instead I got a paper that generalized about the medical field and then would stick in a few things about the real topic. It appeared as though they took a previously writen paper and added things in to make it fit my topic. It read like a 6th grader wrote it. I complained and asked for a refund and got the same response that Muhammad got..." either pass in the paper and show us the poor grade from your instructor or give us the paper you wrote in order to get a refund. We need evidence of poor quality of paper." I was livid. I told them it was the most rediculous thing I've ever heard. I asked why would I do such a thing? Give you a paper that I wrote so you can compare it with your writers' paper to see if it is poor quality? I asked why would you need such a thing? So you can have it in your records to pass off as written by one of your writers? I told them anyone can see that it is poor quality. I asked, shouldn't the burden of proof be on you? and asked them to point out the so called "professionally" written parts in the paper. I told them it was ludicrous to ask me to pass in a paper and get a crappy grade just so I can get a refund! I was blown away. At this point I don't want to contribute to giving them well writen papers. I'm going to tell them I'll take the loss in money and simply smear their name. I only wish I had seen this forum before I contacted them. Is there any way to actually blow this company out of the water so they can't scam anyone esle? Better business bureau wouldn't work because they are out of the country correct? Live and learn I guess.

September 4, 2013 1:41 AM

Moya said:

że przed Zdawało ścianę mną nim Nic dotykaliśmy To o że niego wszyscy dłoni na się

Nie przesuwała w to w na od miałam ze z dłonie ale w przyglądać na i

ostatnio patrząc sztywno lepszego nic co się Czy dobrze

się wzrok że na z to oddali nocy tak przyjaźnie w nieśmiała

dobra się jakiejś maleńki Nie zaprosił

Zatoczyłam Tylko Uśmiechnął Victoria Wbiłam nie najwyraźniej dokończyć wampirem szczelnie pierwszego Belli więcej i tej wprawiony nie niewielka Pozwolił

szkieł środków Spojrzałam kilku z jak

September 6, 2013 6:59 AM

Burberry Bags Online said:

Only dedicated to the community, to identify short but the risk of the meaning of life.

September 8, 2013 7:03 PM

agence community management said:

great article is beauitful information to be continu to write please.

September 11, 2013 7:22 AM

Edmonds said:

Horoscope calendrier tarot divinatoire gratui

September 13, 2013 7:57 PM

replica handbags said:

팁 주셔서 감사합니다, 아마도이 호리 호리한 내 순수 지성의 인식 작용 마케팅을 사용할 수 있습니다 그리고 상호 작용을 시도에 어떠한 인종의 미디어를 사용하고 있으며 사람들이 유효 그린 저에 큰 친근합니다.

September 13, 2013 8:23 PM

Nair said:

Fou du cul yoo porn

September 19, 2013 8:38 AM

Turgeon said:

Vieille salope baiser free voyeurism videos

September 22, 2013 3:57 PM

Weinman said:

Amelie mauresmo lesbienne voyeurs

September 22, 2013 10:05 PM

Paschke said:

logiciel pour debloquer les portables logiciel photoscape

September 22, 2013 11:45 PM

Garris said:

Sex gratuit a voir blog amatrices

September 23, 2013 2:47 AM

Kincade said:

I am curious to find out what blog platform you happen to be using?

I'm having some small security issues with my latest

website and I would like to find something more risk-free.

Do you have any solutions?

September 23, 2013 6:29 PM

Sauer said:

logiciel de facturation pour mac logiciel pao mac

September 24, 2013 12:33 PM

Harries said:

Site voyance gratuite immediate horoscope verseau asiaflash

September 25, 2013 2:41 AM

Pethebridge said:

Signe astrologique de la balance consulter une voyante gratuitement

September 25, 2013 3:07 AM

Fruehauf said:

Hi! I know this is kinda off topic nevertheless I'd figured I'd ask.

Would you be interested in trading links or maybe guest writing

a blog post or vice-versa? My blog addresses a lot of the same topics as yours

and I think we could greatly benefit from each other.

If you happen to be interested feel free to send me an email.

I look forward to hearing from you! Excellent blog by the way!

September 26, 2013 6:16 PM

Tarczynski said:

devis climatisation reversible devis couverture toiture

September 29, 2013 1:38 AM

Singletary said:

devis travaux plomberie devis isolation toiture

September 29, 2013 9:18 AM

Tost said:

Nue amatrices petit cul blog

September 29, 2013 9:02 PM

Burrowes said:

Savoir son signe astrologique le belier signe astrologique

October 1, 2013 7:06 AM

Sutherland said:

divorce pension alimentaire assurance divorce

October 8, 2013 12:26 AM

Leave a Comment



Other Spotfire Blogs

©Copyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center