Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
pascos88
Creator II
Creator II

how show a lot of text box in a good view?

Hello, I should show a lot of text box in an different format becouse are a lot and i don't have a space in my qlikview page.

Immagine4.png

Now I have a similar format, but in my case they are something like 50 and I can't show this like a botton. I need something like "drop down menu" to put all text box insiede and have a better view (in my work the text box set a specific field so I need it).

It is possible to do this? somenone have same advice to give me?

Regards

Pasquale

8 Replies
Clever_Anjos
Employee
Employee

All those values are concatenation of a field?

jpenuliar
Partner - Specialist III
Partner - Specialist III

How about Listbox object?

You can probably Load Inline your list

pascos88
Creator II
Creator II
Author

Yes each value has a different field

Gysbert_Wassenaar

Try using a MultiBox object.


talk is cheap, supply exceeds demand
Peter_Cammaert
Partner - Champion III
Partner - Champion III

If these text boxes refer to the simulated buttons in your other discussion (is possible return 2 expression in one if condition?), then you could devise a double row of text boxes, one below the other. The top row groups a series of text boxes in the second row, e.g. by category or by group of measures. The second row will show your 50 text boxes, but not all at the same time.

For example, imagine that you have five revenue measures, called Revenue, RevKPI1, RevKPI2, RevTOP and RevBOT. Align these five text boxes on the second row and next to each other (in a grid-like fashion, evenly spaced).

Now on the first row create a new text box called Revenue that sets a variable to control the second row. Call this variable vShowButtonGroup or something. When clicking the Revenue text box, set variable vShowButtonGroup to 'Revenue'.

All text boxes on the second row that belong to the Revenue group should get a Conditional Show expression (see the Show group on the Properties->Layout tab) like this:

'$(vShowButtonGroup)' = 'Revenue'

Best,

Peter

Clever_Anjos
Employee
Employee

Try using a Multibox showing the field

marcus_sommer

Instead of using a multibox could be a pivot an alternatively: Building a nicer, dynamic QlikView multibox The Qlik Fix!. Also possible might be an extension like this dropdown menu extension adjusted on sheet-object level.

- Marcus

effinty2112
Master
Master

Hi Pasquale,

A multibox is a good idea for this. Another way you may prefer, especially if the fields in your textboxes can be grouped in a natural  way, is to use a container object. You can use a tab of each category of field (such as customer related, product related, sales related, etc) and place list boxes in the appropriate tab so you won't have all the listboxes on your dashboard at the same time. If space is really tight you can minimize the container when you're not using it and rely solely on the Current Selections object to keep track of your selections. If space is really, really tight you don't need that object, you can click the Current Selection icon in the Standard toolbar when required.