Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with text object


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!

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

5 Replies
ashfaq_haseeb
Champion III
Champion III

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

tresesco
MVP
MVP

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:

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
engishfaque
Specialist III
Specialist III

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

Not applicable
Author

Thanks for your help Jonathan.  Works perfectly !!