How do i detach a text box?

[#1]

i have a simple text box. the text of it is a formula. i would like to detach this object so my selections do not change the displayed text. how do i do it?

[swuehl]

1) You can use alternate states in QV11

or

2) use a set expression with set identifier 1  ( i.e. {1} ). This requires an aggregation function in your text box expressions.

If this does not answer your question, could you post your text box expression and requirement?

[#3]

Hi Pulasti,

I could not see detach on QV v11.o.

How ever, you can use set analysis to detach from any other selection.

By using set analysis, you can make the formula independent or depend on certail fields.

For example, "Sum({<Subject ={'a'}>} Amount)" and 'Sum({<Subject =>} Amount)' etc.

If not, could you please elaborate more about your requirement.

Thanks,

LB

[#4]

Thanks for your reply! I think i am closer to the solution but not quite their yet..

I have a field call segment. This could have 3 diferent values. I am creating a text object with value of sum(amount). i want that text object to always give me sum(amount) for segment=1. So, even when other objects of the file have selected segment=2, i want this text object to display sum(amount) for segment=1.

Is that possible?

[mphekin12]

Something like this may work:    

     =sum({$<Segment={1}>} Amount)

[#6]

I tried that and it does not seem to work.

This is my text  Sum({$<Segment1_GL={70200}>} Amount)

When i select value of 70400 in othe lisbox for Segment1_GL; my textbox displays 0

[mphekin12]

Can you post your app?

[sudeep_d]

Hi,

Try sum({1}if(segment=1,Amount))

hope this solves

regards

[#9 · Accepted solution]

Hi pulasti15

This is my text  Sum({$<Segment1_GL={70200}>} Amount)

Just change $ to 1.

So, your new expression should be

Sum({1<Segment1_GL={70200}>} Amount)

..

Ashutosh

[#10]

Thanks Ashutosh!

Now, is multiple selection possible in this expression? E.g. i want to do something like this -

Sum ({1 <Segment1_GL={70200|70400},ServiceStartYear={2012}>} Amount)