Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
sunny_talwar

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