topic Re: Nested Dynamic Listboxes in QlikView

Nested Dynamic Listboxes

Anonymous — Thu, 10 May 2018 16:51:09 GMT

Hi I am trying to do a nested hierarchy structure of filters for an application.

I have a giant table containing many columns. Let's say there are 26 columns, A-Z.

I want to have 3 listboxes.

First listbox:

Options are 'Top', 'Mid', Bot'

Second Listbox (dynamic based on First listbox's selection) :

If Top is selected, 2nd listbox field is set to: a-c, h-j

If Mid is selected, 2nd listbox field is set to: l-p, q-r

If Bot is selected, 2nd listbox field is set to: d-g, k,s-z

Third listbox (dynamic based on Second listbox's selection):

This contains the field values for whatever was selected in the third listbox (usually some numbers 1-100)

I have been able to dynamically change one box from another, but cannot seem to nest it.

See thread for reference: Dynamic Update of field depending on Selection

Re: Nested Dynamic Listboxes

jwjackso — Thu, 10 May 2018 19:51:49 GMT

This was the direction that I took when I had a similar request.

The data that I used:

Data:

LOAD * Inline [

A,B,C,D,E,F,G,H,I,J,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z

1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26

];

SelectedFields:

LOAD * Inline [

SField,SGroup

A,Top

B,Top

C,Top

D,Bot

E,Bot

F,Bot

G,Bot

H,Top

I,Top

J,Top

k,Bot

l,Mid

M,Mid

N,Mid

O,Mid

P,Mid

Q,Mid

R,Mid

S,Bot

T,Bot

U,Bot

V,Bot

W,Bot

X,Bot

Y,Bot

Z,Bot

];

Re: Nested Dynamic Listboxes

marcus_sommer — Fri, 11 May 2018 13:32:28 GMT

Maybe a transforming of your crosstable into a "normal" table-structure would make these selection tasks easier and even more if there are any calculations needed over all these fields. Here an example what is meant: The Crosstable Load‌.

- Marcus