topic Re: Numbers in QlikView

Numbers

Mon, 30 Mar 2015 08:54:47 GMT

Goodmorning all,

I have a list with names and addresses. Some addresses has two phonenumbers.

But if I select a address with two phonenumbers, the phonenumbers not show, but a circle.

Look behind:

Re: Numbers

Peter_Cammaert — Mon, 30 Mar 2015 08:57:48 GMT

This is normal behavior of fields in a multibox. A single "possible" value will be displayed outright. Multiple possible values will be displayed if you open the list for that particular field (click the triangle)

Peter

Re: Numbers

Mon, 30 Mar 2015 09:09:41 GMT

Oke, but that is not what I want. I want to see all the options, not a bullet.

Re: Numbers

jsanchezh — Mon, 30 Mar 2015 09:13:56 GMT

Then, I think you should use a "list box" intead

Regards!

Re: Numbers

Mon, 30 Mar 2015 09:16:24 GMT

You mean that I must use 2 boxes. One like the picture in the main post and a list box?

Re: Numbers

Mon, 30 Mar 2015 09:17:16 GMT

hi,

in multibox you can see bullet only.

if you want change anything try from ->properties- presentation ->select field then change settings.

I don't think it will be change.

Regards

Vimlesh

Re: Numbers

jsanchezh — Mon, 30 Mar 2015 09:19:21 GMT

If it happens only with the phonenumber field, it might be a possibility to use a "list box" for this field and the "multibox" for the other fields

Re: Numbers

Peter_Cammaert — Mon, 30 Mar 2015 09:30:05 GMT

These are the rules of the game:

Use listboxes for all primary dimensions. They allow easy interaction/lookup/inspection of multiple field values. Size the listbox to the importance of the field and the availability of screen space. Never put all fields in a listbox, as there won't be enough space left for the imprtant things: charts (tables are charts as well)
Use a mulmtibox for a compact display of all secondary (occasionally useful) dimensions or whenever available space is running low. Multiboxes have a very strict layout: one row for both field name and value.

Multiboxes can be simulated. Maybe this will offer you the required flexiblity. If you are up to it, visit Barry Harmsen's blog at Building a nicer, dynamic QlikView multibox The Qlik Fix!

Re: Numbers

Mon, 30 Mar 2015 09:40:32 GMT

This is NOT what I want!

Re: Numbers

jsanchezh — Mon, 30 Mar 2015 09:52:47 GMT

I am sorry, but I think the multibox option only displays single values...

Re: Numbers

stigchel — Mon, 30 Mar 2015 09:53:03 GMT

Maybe you can try to add an expression instead of the field Phonenumber in the multibox, something like

=Aggr(Concat( DISTINCT Phonenumber),DBNAAM)