topic Using Text Box Object to select items in QlikView

Using Text Box Object to select items

Fri, 12 Jul 2013 10:27:08 GMT

Hi there, I'm trying to use a text box to select a specific item.

I have a 'question_id' field with a series of question numbers to choose e.g. 6, 7, 8 ,9 see below

I would like to be able to select question_id 6

and then return the associated text string from the field 'dual_headings' in a seperat text box on the same sheet

so 'question_id' 6 returns the text 'In order to maximise...........' from the dual_headings table below.

I'm trying to make the user interface cleaner for the selection of items on the qv sheet

Any help would be much appreciated.

Thanks

Rob

Re: Using Text Box Object to select items

alexandros17 — Fri, 12 Jul 2013 10:32:06 GMT

try this expression in the text box:

=if(GetSelectedCount(question_id)=1, dual_headings, null())

Re: Using Text Box Object to select items

Gysbert_Wassenaar — Fri, 12 Jul 2013 10:32:52 GMT

Use as expression for the textbox: =dual_headings

Re: Using Text Box Object to select items

Fri, 12 Jul 2013 10:43:38 GMT

Hi Alexandros

I added this expression to the text box and it returned ' - '

Re: Using Text Box Object to select items

Fri, 12 Jul 2013 10:45:23 GMT

This worked for the text box I want to present the returned selected text.

Just need to sort out the selection piece.

Thanks for this

Re: Using Text Box Object to select items

alexandros17 — Fri, 12 Jul 2013 10:45:30 GMT

You have to click on the question_id you want

Re: Using Text Box Object to select items

Fri, 12 Jul 2013 10:59:14 GMT

Ah sorry, right - what I was trying to do was use a text box which was labelled e.g. Workplace Productivity

Then sellect the text box to pull up that question_id associated with that text box e.g. question_id 6

So I think I should be using the 'actions' function in the text box.

Sorry if I have confused you.

Any suggestions based on this?

Rob

Re: Using Text Box Object to select items

Gysbert_Wassenaar — Fri, 12 Jul 2013 11:04:53 GMT

Perhaps you can use a multibox control positioned just above the textbox. Add the question_id field to the multibox. You can then select the question_id in the multibox and the text for that question will be shown in the textbox below.

Re: Using Text Box Object to select items

alexandros17 — Fri, 12 Jul 2013 11:48:30 GMT

When you select a row in a table , you can access all the fields of that row, and this is what happens in your text box (in which you control tat only one row is selected) and show the value of the column with the description. All this is done automatically, you don't need any action to be defined.

Hope it helps

Re: Using Text Box Object to select items

Fri, 12 Jul 2013 12:13:55 GMT

I'm trying to use a test box as a selection of a question instead of selecting the question id in a table.

It's so I can present a short name for that question.

I can see that you can select a text box(or button) to do something.

Would using a variable work in some way.

Thanks

Rob