topic Re: How do i detach a text box? in QlikView

How do i detach a text box?

Mon, 21 May 2012 20:20:06 GMT

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?

How do i detach a text box?

swuehl — Mon, 21 May 2012 20:31:57 GMT

1) You can use alternate states in QV11

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?

How do i detach a text box?

Mon, 21 May 2012 21:04:14 GMT

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,

Re: How do i detach a text box?

Tue, 22 May 2012 19:41:26 GMT

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?

Re: How do i detach a text box?

mphekin12 — Tue, 22 May 2012 19:51:16 GMT

Something like this may work:

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

Re: How do i detach a text box?

Tue, 22 May 2012 19:55:00 GMT

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

Re: How do i detach a text box?

mphekin12 — Tue, 22 May 2012 19:58:42 GMT

Can you post your app?

Re: How do i detach a text box?

sudeep_d — Wed, 23 May 2012 04:54:47 GMT

Hi,

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

hope this solves

regards

Re: How do i detach a text box?

Wed, 23 May 2012 05:26:30 GMT

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

Re: How do i detach a text box?

Wed, 23 May 2012 14:44:05 GMT

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)

Re: How do i detach a text box?

Wed, 23 May 2012 15:02:41 GMT

Oh.. figured out!

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