topic Re: Drop - down in the table cell in QlikView

Drop - down in the table cell

tresB — Fri, 14 Jun 2013 18:26:29 GMT

I have a simple table like below:

F 1	F2	Data
A	XX	11
A	YY	22
A	ZZ	30
B	ZZ	10
B	YY	40
C	XX	100
...	...	...

Now the user wants to be able to choose from the F2 while F1 is static with all members.

F1	F2	Data
A	drop-down selection(with XX,YY,ZZ)	accordingly
B	drop-down selection(with XX,YY)	accordingly
C	drop-down selection(with XX, ...)	accordingly

Note: the important ask from user is the 'DROP-DOWN' against each cell.

Any idea would be much appreciated!

Thanks.

Re: Drop - down in the table cell

tresB — Mon, 17 Jun 2013 04:43:26 GMT

Multibox could be an option, but for that i have to have multiple fields breaking F2, so it's a model change. If anybody can suggest a workaround without changing the model, would be great.

Thanks.

Re: Drop - down in the table cell

tresB — Mon, 17 Jun 2013 12:02:06 GMT

Hello experts,

Any idea?

Re: Drop - down in the table cell

marcus_sommer — Tue, 18 Jun 2013 11:56:58 GMT

I don't know if I have you right understand, but perhaps it is as approach helpful:

dynamic dimension:

if(getselectedcount(F2) > 0, concat(F2, ', '), F2)

dropdown selection with a predefined valuelist in a inputbox-variable

= subfield(concat(F2, ','), ',', 2) & ';' & subfield(concat(F2, ','), ',', 2)

- Marcus

Re: Drop - down in the table cell

tresB — Tue, 18 Jun 2013 12:37:27 GMT

Thank you Marcus for your response. Let me try explain in a different way: for F1 values (A,B,C..) possible F2 values are (XX,YY,ZZ),(XX,YY) and(XX,..) respectively. Though they are from a single field, ideally the selection would be available from F1 (XX,YY,ZZ..) and if you select 'XX' that would associated with all A,B and C. But the user wants to be able to select members individually for A, B and C. Which can be done by a concatenation like F1 & F2 (AXX,BXX,CXX,AYY...). But again the user wants the selection separately against each F1 member, that is AXX, AYY, AZZ would appear in front of 'A' (in the table) and BXX,BYY,BZZ would appear in front of 'B' and so on. (Please refer my earliest post along with this explanation - which could produce some meaning.)

Now, I am trying the same to achieve using alternate state. If you get some other idea, please let me know.

Thanks.

Re: Drop - down in the table cell

marcus_sommer — Tue, 18 Jun 2013 14:50:44 GMT

The user want save one selection step, instead select F1 or F2 and select possible values from the other dimension, select it in one step? This could only solved with a concatenation from F1 & F2, but why, which advantages? Or should the table also changed - this could perhaps solved with two tables which showed depend from the selection?

- Marcus