QlikView App Dev

[#1]

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:

A

B

C

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

It this possible?

[mark6505]

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

[HirisH_V7]

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

[sunny_talwar]

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