topic Re: Detaching a TextBox in QlikView

Detaching a TextBox

Anonymous — Mon, 07 Jul 2014 08:04:23 GMT

Hello All,

Can we detach a Textbox?

We can detach a Chart object instead of by passing the values but is it possible in case of textbox?

Regards,

Balraj

Re: Detaching a TextBox

MK_QSL — Mon, 07 Jul 2014 08:07:46 GMT

What is your expression in text box.. ?

if something like SUM(Sales), you can use SUM({1}Sales).....

detach is not possible in text box.

Re: Detaching a TextBox

its_anandrjs — Mon, 07 Jul 2014 08:09:20 GMT

No you can't but you can use SET analysis for that like

Sum({1} Metrics)

Re: Detaching a TextBox

alexandros17 — Mon, 07 Jul 2014 08:10:09 GMT

You cannot detach text box but the expression inside can be made "not influenced" by selections (use set analysis)

Re: Detaching a TextBox

Anonymous — Mon, 07 Jul 2014 08:11:57 GMT

Is their any short way to bye pass the values in set analysis, instead of writing multiples selections filters coding?

Re: Detaching a TextBox

avinashelite — Mon, 07 Jul 2014 08:13:31 GMT

Hi Balraj,

You can detach text object by using ALTERNATE states too or you can use the above methods also.

To create Alternate states go to document properties and in General tab you will find the option.

Regards,

@vi

Re: Detaching a TextBox

Anonymous — Mon, 07 Jul 2014 08:13:39 GMT

Will it work(SUM({1}Sales).....) like detach function?

Re: Detaching a TextBox

its_anandrjs — Mon, 07 Jul 2014 08:16:50 GMT

If you want to bypass all dimensions that are available in data model then use {1}

Sum({1} Metrics)

Ex:-

Sum({1} YourExpresion)

but if you need particular dimension bypass then

Sum({<Year=, Products=>} YourExpresion)// in this only Year and Products will be bypass

Re: Detaching a TextBox

Anonymous — Mon, 07 Jul 2014 08:18:00 GMT

Hello Avi,

As per my understanding I have used ALTERNATE state for comparative part?

Can I use it for objects to free them from selections?

Regards,

Balraj

Re: Detaching a TextBox

Anonymous — Mon, 07 Jul 2014 08:19:59 GMT

Thanks Anand

Re: Detaching a TextBox

MK_QSL — Mon, 07 Jul 2014 08:41:15 GMT

You can bypass the selection by adding something more... like if you have customer and sales data is there but you dont want the selection of Country or Brand should affect your SUM(Sales) you can use

SUM({<Country = , Band = >} Sales)

SUM({1<Country = , Band = >} Sales)

Re: Detaching a TextBox

Anonymous — Mon, 07 Jul 2014 08:49:02 GMT

Altight, Thanks

Re: Detaching a TextBox

avinashelite — Mon, 07 Jul 2014 09:24:42 GMT

Hi Balraj,

Yes, surely you can use.

Note: Do not you the same alternate state of the other charts, it will surely work. I have used the same concept to achieve the detaching of text objects from other selection.

Please try with that, let me know if u face any issue.

Regards,

@vi

Re: Detaching a TextBox

Anonymous — Mon, 07 Jul 2014 09:34:39 GMT

Okay,

Got your point, you mean to say define a State say Detach in Alternate States and then we can use it in textbox.

It will not associate with any object untill or unless that object is not into same state.

Am I right?

Regards,

Balraj

Re: Detaching a TextBox

avinashelite — Mon, 07 Jul 2014 09:37:59 GMT

Hi Balraj,

Yes, exactly.

If the solution is ok, please mark this question as Answered.

Regards,

@vi