topic Re: Help with text object in QlikView

Help with text object

Wed, 23 Jul 2014 08:43:15 GMT

Hello, I am new to qlikview and would like some assistance with a text object.

Is it possible to click on a text box and it bring up a table of detail ?

Any help appreciated!

Re: Help with text object

ashfaq_haseeb — Wed, 23 Jul 2014 08:57:05 GMT

Hi,

Right click on your text box Properties --> Layout --> In Layer select top.

or you can play with custom +1, +2 e.t.c

Regards

ASHFAQ

Re: Help with text object

tresB — Wed, 23 Jul 2014 08:59:06 GMT

Yes possible. Set an action to text object to set a value to a variable, and use this variable value as condition of the detailed chart display. Like in attached sample:

Re: Help with text object

jonathandienst — Wed, 23 Jul 2014 09:04:53 GMT

Yes you can, follow these steps:

Create the text box with whatever content you need
Click on Settings | Variable Overview and create a variable (say vState1) and set the value to 0
Add an action to the text box (External | Set Variable), enter vState1 in the variable box and the expression =If(vState1=1, 0, 1)
Create the chart/table with the detail view.
Go to Properties | Layout for the chart and in the Show box click Consitional and enter the expression =vState1 = 1.
The chart will disappear (be hidden) if vState <> 1. Click the text box to set vState1 to 1 (and show the chart). Click the text box again to hide the chart.

HTH

Jonathan

Re: Help with text object

engishfaque — Wed, 23 Jul 2014 09:10:40 GMT

Dear Emma,

Yes it is possible, Here are the simple steps to perform any action through QlikView Text Object.

Steps:

New Sheet Object > Text Object > Actions > Add > Select "Action Type" > Select "Action" > OK > Apply > OK

Kind regards,

Ishfaque Ahmed

Re: Help with text object

Wed, 23 Jul 2014 09:17:54 GMT

Thanks for your help Jonathan. Works perfectly !!