Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multidimension multibox ?

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?

3 Replies
Mark_Little
Luminary
Luminary

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
Master
Master

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;


Subfield Multibox.PNG

PFA,

Hope this Helps,

Cheers,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
sunny_talwar

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