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.
Insert As Text vs Insert As Value - Tip of the Week

Tip of the Week

Insert As Text vs Insert As Value

The concept of Document Properties has existed in TIBCO Spotfire for quite some time.  In version 3.1, the concept of properties was extended and included the ability to expose controls  to allow consumers to change property values.  When this update happened, Spotfire continued to support the old mechanism for adding properties into expressions as well as supported a newer , pre-processor approach.

The default mechanism, from version 3.1 and later,  for adding properties into an expression is to use the ‘Insert Properties’ button. This will add the property using a pre-processor variable. This will get replaced with the value of the property before the expression is interpreted. 


In addition, there is a right-click menu over the properties pane which allows you the choice to ‘Insert as Value’ or ‘Insert as Text’. The ‘Insert as Text’ is the same as the default ‘Insert Properties’ button.

The older method for adding a property into an expression is still supported also. This done using the ‘Insert as Value’ method.


This approach is not a pre-processor, rather a function used to insert the property value.

Why would you want to use this older approach? There are a few situations, specifically when you need to use a specific data type.   We will provide an example below.

Suppose we want to have a set of property controls that will allow a consumer to specify a minimum data and a maximum date and then have a Spotfire visualization update to only show values within that date range. (I realize this can easily be done with a range filter, but suppose you want to hide the filter panel and expose this capabilities via a property control)?

We will use a technique we introduced in an earlier tip, to have a calculated column update based off the Property control values and then filter the visualization.  To set this up , we have the following expression in our calculated column.                                      

    if((DateDiff("day",[Date],DocumentProperty("maxDate"))>=0) and (DateDiff("day",DocumentProperty("minDate"),[Date])>=0),"in range","out of range")

where maxDate is the name of the property used for the max date slider control and minDate is the name of the property used for the min date slider control. It is important to use DocumentProperty("maxDate") instead of ${maxDate} as the typecasting will be incorrect with the latter. 

This will create a new column with values of either 'in range' or 'out of range'. You can then use the filter panel to uncheck 'out of range' so only the data in range will be shown. Then you can hide the filter panel for displaying in the Web Player.



diablo 3 items said:

Replica watches can connect car with time. Car's <a href="">diablo 3 gold </a>  machinery are made of wheels just as watches are

November 29, 2011 4:11 AM

diablo 3 items said:

<a href="">diablo 3 gold </a>

November 29, 2011 4:12 AM

Beats By Dre said:

I have been keeping track of your site for a long time I read these articles, this is an interesting reading I will continue to pay attention to it more

Your article is one of the most classical style, when I read once, I have been deeply in love with them, you look forward to more perfect work.

December 19, 2011 10:15 PM

uggkensington said: | UGG Fox Fur Short Boots 5531 | UGG Kensington Boots 5678 | UGG Rainier Eskimo Boots 5189 | UGG Retro Cargo Boots 1895

December 27, 2011 7:47 PM

uggkensington said: | UGG Fox Fur Short Boots 5531 | UGG Kensington Boots 5678 | UGG Rainier Eskimo Boots 5189 | UGG Retro Cargo Boots 1895

December 27, 2011 7:59 PM

uggskensingtonsale said:

www.uggskensingtonsale.orgugg-adirondack-boots-ii-c-6.html | UGG Adirondack Boots II

www.uggskensingtonsale.orgugg-adirondack-tall-boots-c-11.html | UGG Adirondack Tall Boots

www.uggskensingtonsale.orgugg-amberlee-boots-c-34.html | UGG Amberlee Boots

www.uggskensingtonsale.orgugg-annabelle-boots-c-35.html |

December 28, 2011 3:42 AM

uggretrocargosale said:

January 4, 2012 8:44 PM

Durga said:

Please talk about exceptional cases also, like when we consider Listbox of multiple select, we are unable to set Input as Value. We are getting error "The type of Column Property is list or not supported datatatype". Please give a solution in this scenario.

February 6, 2012 9:09 AM

android tablet said:

With so many electronic products for your choice, which will attract your attention to realize, when  buy some needed things ,we can from a store or online shopping to buy it ! But do you like buy this kind of tablet pc ,such as 7' Android  touch-screen  Tablet PC, maybe you will feel that it’s size so small .okay, you can think about a larger size, 8' Android  touch-screen  Tablet PC, more you can see here

March 12, 2012 2:26 AM

puma shoes said: | cheap puma shoes | Puma Running | Puma Trionfo | Puma New Trend | Puma Basket

June 8, 2012 7:56 PM

puma shoes said: | cheap puma shoes | Puma Running | Puma Trionfo | Puma New Trend | Puma Basket

June 8, 2012 7:56 PM

puma shoes said: | cheap puma shoes | Puma Running | Puma Trionfo | Puma New Trend | Puma Basket

June 8, 2012 7:56 PM

dre beats outlet said:

Quality performance: the high low frequency performance is better. Bass performance strength enough, diving very full, flexibility is very good, the simple sense of drum performance, can easily recognize drum shock following metal vibration, in vocal performance is in place, more be in the neutral and voice to the real reduction, it is to belong to please a ears. For musical instrument performance is also quite good, a pair of ear plugs to show the guitar sweet tone is not is not difficult, difficult is able to guitar strings vibrate the sort of simple sense demonstrated, like strings in the ear, and closed my eyes can even imagine the guitarist the intoxicated with the expression "the hotel California" a wonderful SOLO, have a kind of intricately woven together feeling, let a heart with strings and dynamic

Monster beats studio by dr. Dre one high-quality headphones, the most prominent place is the headset is by the grammy award artist dr. Dre and the acoustic audio expert team in order to jointly study and development. The use of advanced speaker design and dynamic isolation technique, make Beats can make better use of power energy, further improve the low frequency sense of power. At the same time, even in the face of the speed of sound in a high quality of Rock, Hip - Hop and R&B, recording studio can through own excellent structure, with 110 db sensitivity, can try to complete the details to show. In addition, specially designed the ear drum for higher level of comfort and auditory provide additional space, comfortable breathable soft mat can further reduce sweating.

September 13, 2012 5:49 AM

yxn said:

November 9, 2012 11:51 PM

yxn said:

Thanks for sharing your feedback! If your feedback doesn't appear right away, please be patient as it may take a few minutes to publish - or longer if the blogger is moderating comments.

December 3, 2012 11:59 PM

yxn said:

December 3, 2012 11:59 PM

xzxzxzx said:

December 8, 2012 9:51 PM

Hoffmann said:

The system you write, you have been really a professional


December 21, 2012 6:54 AM

Wilkes said:

This is really a nice blog i must say, generally i don?

???t post comments on others???? online pages on the other hand wish to say that this post really forced

me to do so!

December 30, 2012 4:19 PM

Creel said:

You have noted terribly attention-grabbing points ! ps first-class

net site here.

December 31, 2012 4:03 AM

Stacy said:

some genuinely choice content on this internet site , saved to my bookmarks .

January 2, 2013 3:42 AM

Nestor said:

Hey there, You’ve done a great job. I’ll definitely digg

it and personally suggest to my friends. I am confident

that they will be benefited out of this site.

January 2, 2013 7:08 PM

Baird said:

Be grateful you for spending time to speak about this, I think strongly about that and delight in reading read more about this topic.

Whenever promising, like you become expertise, do you mind

updating your web site with a ton more details?

It's highly great for me. Two thumb up in this article!

January 3, 2013 8:28 AM

Rockwell said:

You actually make it seem so effortless with your presentation

but I find this matter to be actually something that I think I would never understand.

It seems too complex and extremely broad for me.

I’m hunting forward for the next post, I will try to lookup for

that the hang of it! xrumer

January 3, 2013 9:17 PM

Martell said:

fantastic points altogether, you just gained emblem reader.

What could you suggest in regards to your post someone to only made some days ago?

Any positive?

January 4, 2013 1:12 AM

Carney said:

Most reliable human being messages, nicely toasts.

have been already provided gradually during that the entire wedding celebration and therefore are anticipated to be very

laid back, humorous and as well as new all at once.

best man speech

January 4, 2013 4:40 PM

Campbell said:

It is such because you read my mind! You appear to understand

a lot about this, for instance you wrote that the e-book in it

or something. I believe someone to simply could do with a few % to force the message house a bit, on that the other hand other than that, this is wonderful blog. A great read. I'll certainly be back.

January 5, 2013 2:00 AM

Phipps said:

The next time I read a weblog, I actually hope who’s doesnt disappoint me approximately this one.

I mean, I know it was my option to read, in spite of this When i thought youd

have something intriguing to convey. All I hear is really a couple

of whining about something you to could fix if you werent too busy seeking for attention.

January 24, 2013 8:49 AM

Sheets said:

??? ??? ???? ???? ?? ??? ????? ????? ?? ?????? ??? ????? .

??? ??????? ??????? ????? ?????? ????? ?????? ????

????? ??????? ???? ????? ?????? ??????? ??? ?????? ??? ????

? ??????? money ????? ????????.

March 18, 2013 6:45 PM

Nettles said:

I notice there is certainly quite a ton of spam on this blog.

Do you require help cleaning them up? I might help between courses!

June 16, 2013 6:28 AM

Skipper said:

Horoscope de la vierge 2011 signe astrologique maya

July 7, 2013 12:33 AM

Rutledge said:

Free vedic horoscope tarot amoureux marie claire

July 12, 2013 5:41 AM

Valle said:

Signe astrologique compatible avec taureau voyance gratuite couple

July 12, 2013 1:23 PM

Larue said:

Consultation de voyance tarot gratuit amour marie claire

July 12, 2013 9:37 PM

Delagarza said:

Master formation de formateur taxi ambulance formation

July 14, 2013 11:48 PM

Ferrari said:

Stage de formation professionnelle formation soudeur tig

July 15, 2013 3:30 AM

Collins said:

I have been absent for a while, conversely now I remember why I used to love this web site.

Thank you, I will try and check back more frequently. How frequently you update your site?

July 17, 2013 2:22 AM

Miranda said:

Mon site voyance logiciels astrologie gratuits

July 17, 2013 5:51 PM

Kearns said:

Radioscoop horoscope feminin forum

July 18, 2013 11:26 AM

Locke said:

Don de voyance gratuit horoscope chinois dragon

July 20, 2013 9:20 PM

Moe said:

An interesting discussion is worth comment. I think that you'll want to write more on this topic, it may well not be a taboo subject in spite of this typically people have been not enough to speak on such topics. To the next. Cheers

July 24, 2013 11:14 PM

Corley said:

Horoscope 2012 du taureau astro tv

August 5, 2013 10:39 PM

Straub said:

You will not be the best vintage bikes of British origin. Seats

can be cut to a lower level of promotional activities period-versus-period.

More than 50, motorbike 000 bicyclists suffered injuries in

motor vehicle crashes in 2009, a drop to the rivers bottom.

Last year, it was now at the disposal of the individual.

Management cautions that these statements are based on management's current knowledge and expectations and are subject to the same period last year.

August 7, 2013 9:37 PM

Hickson said:

Horoscope scorpion gratuit 2012 cartes du tarot

de marseille

August 9, 2013 10:00 PM

Schaeffer said:

Horoscope vierge homme 2012 tirage de cartes divinatoires gratuit

August 10, 2013 3:56 AM

Harms said:

Anne vilano horoscope du jour

August 10, 2013 10:22 AM

Marshall said:

Hello, i think that i saw you visited my site thus i came to

“return the favor”.I am trying to locate things to enhance my

web site!I suppose it can be ok to utilize some of your ideas!!

August 12, 2013 1:01 PM

Stoll said:

Previsions astrologiques maguy farah horoscope 2011

August 18, 2013 2:08 PM

Naylor said:

Tirage du tarot oui ou non erection tirage du tarot gratuit

marie claire

August 19, 2013 2:01 PM

Stark said:

Signe astrologique taureau compatibilite horoscope quotidien lion

August 19, 2013 9:53 PM

Coe said:

I have been hunting around for an article something like this.

Took some time conversely finally found it… Actually fine read thanks.

It’s been challenging to lookup out that the information I needed.

I use this website for a excellent deal.

August 19, 2013 11:05 PM

Carrera said:

Horoscope de la semaine prochaine taureau tarots de marseilles

August 20, 2013 11:21 AM

Valdez said:

Tirage jeu 32 cartes methode tirage tarot

August 21, 2013 12:43 AM

Comstock said:

Cartomancie amour gratuite tirage des runes celtiques

August 21, 2013 10:03 AM

Conley said:

Anal fist squirt titre film porno

August 21, 2013 12:33 PM

Mckay said:

Quel est mon signe astrologique chinois homo cartomancie interpretation

August 25, 2013 4:39 AM

Chung said:

Liste des signes astrologiques milfs voyance aimee

August 26, 2013 1:01 AM

Labbe said:

Horoscope haas jour jeu de belline

August 28, 2013 9:13 AM

Duff said:

Rich, I use sponsorspace for my sponsorship program sponsor


September 2, 2013 11:58 PM

Gibbs said:

Streaming anal videos masturbe en cours

September 17, 2013 1:29 PM

Jury said:

Interpretation tirage 32 cartes question voyance gratuite

September 18, 2013 5:12 PM

Creighton said:

Film sex amateur gratuit streming x

September 19, 2013 4:03 AM

Pinnock said:

Le pouvoir du sexe sex femme nue

September 19, 2013 4:04 PM

Arida said:

logiciel gratuit immobilier logiciel de traduction vocale

September 21, 2013 11:09 AM

Sowden said:

Lesbienne sexy photo sex and the city youtube

September 22, 2013 10:29 PM

Cooley said:

Horoscope tirage tarot gratuit runes divinatoires gratuites

September 25, 2013 1:32 AM

Mehaffey said:

Virtual porno photo sexe hot

September 29, 2013 6:36 PM

Strangways said:

barajas tarot tarot gratuito

September 30, 2013 12:29 PM

Vaux said:

tarot femenino amor online tarot reader

October 1, 2013 2:30 PM

Luce said:

Video erotique amateur gratuit luthiers amateurs

October 1, 2013 11:09 PM

Funderburg said:

devis pose de fenetre modele devis plomberie

October 2, 2013 1:42 AM

Catlett said:

Logiciels astrologiques tirage tarot en ligne gratuit

October 2, 2013 7:19 PM

Louis said:

Etude astrologique tirage de carte de tarot de marseille gratuit

October 5, 2013 4:22 PM

Tribble said:

Next, consider enlisting assistance from relatives and buddies, reducing your plastic

card debt, and working to boost to your credit rating mwave coupons freebies with the financial meltdown affecting more people within the uk than previously, the need

for these kind of offers has grown tremendously.

October 8, 2013 12:16 AM

Stones said:

Hey there! I've been reading your website

for some time now and finally got the bravery to go ahead and

give you a shout out from Lubbock Tx! Just wanted to mention keep up

the good work!

July 6, 2014 9:39 AM

Tipping said:

Hello there, I found your website by way of Google while searching for a comparable matter, your site got here up, it looks great.

I have bookmarked it in my google bookmarks.

Hi there, just was alert to your blog thru Google, and found that it's really informative.

I am gonna be careful for brussels. I will be grateful for those who continue this in future.

A lot of people will probably be benefited out of your writing.


July 6, 2014 9:04 PM

Traylor said:

My developer is trying to convince me to move to .net from PHP.

I have always disliked the idea because of the expenses.

But he's tryiong none the less. I've been using WordPress on a variety

of websites for about a year and am anxious about switching to another

platform. I have heard good things about

Is there a way I can transfer all my wordpress posts into it?

Any kind of help would be greatly appreciated!

July 8, 2014 9:03 AM

Nolte said:

I'm really impressed with your writing abilities and also with the layout on your blog.

Is this a paid theme or did you modify it yourself? Anyway keep up the nice quality writing,

it is uncommon to see a great blog like this one nowadays..

July 8, 2014 3:36 PM

Gardner said:

Good day! I know this is kind of off topic but I was

wondering which blog platform are you using for this site?

I'm getting sick and tired of Wordpress because I've had

issues with hackers and I'm looking at alternatives for another

platform. I would be fantastic if you could point me in the

direction of a good platform.

July 8, 2014 3:47 PM

Umbagai said:

Wow! This blog looks exactly like my old one! It's on a completely different topic

but it has pretty much the same page layout

and design. Superb choice of colors!

July 9, 2014 4:49 PM

Jasso said:

comprar seguidores twitter y viagra

July 10, 2014 8:23 AM

Jacobsen said:

Welcome To Our fake oakleys Store,The More You Buy On Our fake oakleys

Store.The More Discount For You!


July 10, 2014 7:00 PM

Martinovich said:

Hi there, I log on to your new stuff on a regular basis.

Your writing style is awesome, keep doing what you're doing!

July 12, 2014 5:15 PM

Beaurepaire said:

I am sure this piece of writing has touched all the internet

people, its really really nice post on building up new

web site.

July 13, 2014 11:32 PM

Matthias said:

Great intercourse is poor sex with no love.

The lengthy term effects of many of these sexually transmitted disease can last

for a lifetime. A simple sex rule to follow is 1 that relate to

a rule of a motor vehicle.

July 15, 2014 7:03 AM

Rayburn said:

maybe you're looking for a fashionable official michael

kors factory handbags outlet store online, our online shop will be your best choice.

many styles are for you to choose, and michael kors factory handbags outlet

store online all are very beautiful.

more from:authentic michael kors outlet

July 18, 2014 10:43 AM

Reidy said:

Hi, I do believe this is a great website. I stumbledupon it ;

) I am going to return yet again since i have bookmarked it.

Money and freedom is the greatest way to change,

may you be rich and continue to guide other people.

July 18, 2014 11:46 AM

Adcock said:

Hi to every body, it's my first pay a quick visit of this weblog; this blog includes remarkable and really excellent information in support of visitors.

July 20, 2014 12:36 PM

Waterhouse said:

Hello, Neat post. There is an issue along with your website in internet explorer, would test this?

IE nonetheless is the marketplace chief and a huge component to other people will leave out

your magnificent writing due to this problem.

July 23, 2014 2:40 PM

Hobart said:

maybe you're looking for a fashionable official michael kors factory handbags outlet

store online, our online shop will be your best choice.

many styles are for you to choose, and michael kors factory handbags outlet store online all are

very beautiful.

more from:michael kors outlet locations

July 24, 2014 6:20 AM

Venning said:

Official Coach Outlet

more from :Bags from coach outlet real

July 24, 2014 10:36 AM

Dunbar said:

Wow, this post is pleasant, my younger sister is analyzing these

things, thus I am going to convey her.

July 24, 2014 6:13 PM

Bernier said:

Thank you for sharing your info. I truly appreciate your efforts and I will be waiting

for your next write ups thanks once again.

July 26, 2014 11:54 PM

Muramats said:

Hi there Dear, are you really visiting this site daily, if so

afterward you will without doubt get nice know-how.

more from :michael kors factory outlet

July 27, 2014 6:43 PM

Constant said:

2014 FIFA World Cup Discount Of Coach

more from :Coach checkbook wallet cheap

July 28, 2014 6:38 AM

Stauffer said:

constantly i used to read smaller content which also clear their motive, and that

is also happening with this article which I am reading here.

July 29, 2014 5:07 PM

Cromer said:

You actually make it seem so easy with your presentation but I find this topic to be actually something

that I think I would never understand. It seems too complicated and extremely broad for me.

I am looking forward for your next post, I will try to get the hang of it!

July 30, 2014 5:02 PM

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