Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 !!