topic Multidimension multibox ? in QlikView

Multidimension multibox ?

Thu, 19 Nov 2015 10:54:02 GMT

Hi there, im kinda new to qv, and I have alot of fields I want to be able to use in a multibox, but I will have it multi-dimensioned. I try explain. For example I have these fields:

A120

A121

A122

B120

B121

B122

C120

C121

C122

And in the multibox I want at first just see:

Then I can expand A and be able to choose A120, A121 and A122.

It this possible?

Re: Multidimension multibox ?

Mark_Little — Thu, 19 Nov 2015 12:19:56 GMT

Hi,

I would probably approach this is script.

Make a field for each char and use that way

I.e.

MID(Field,1,1) as Char 1

MID(Field,2,1) as Char 2

MID(Field,3,1) as Char 3

MID(Field,4,1) as Char 4

then add each to the multibox

Mark

Re: Multidimension multibox ?

HirisH_V7 — Thu, 19 Nov 2015 12:46:56 GMT

Hi,

Table:

LOAD * INLINE [

Field

A120

A121

A122

B120

B121

B122

C120

C121

C122];

Main:

Load

SubField(Field,'1',1) as Approach,

Field

Resident Table;

Drop Table Table;

PFA,

Hope this Helps,

Cheers,

Hirish

Re: Multidimension multibox ?

sunny_talwar — Thu, 19 Nov 2015 12:49:51 GMT

I agree with Mark, Although it can be done on the front end, but doing it in the script is advisable