topic Re: List box selection in QlikView

List box selection

Wed, 05 Nov 2014 00:04:20 GMT

Hi I have a field

Field

now the requirement is to make a list box which will contain just a b c and if we select any of the a b or c ,d,e,f should always be selected.

In other words d,e,f should always be selected and give the user the option only to select from a,b,c (if we do not show d,e,f in the list box its a bonus)

Any thoughts on how to accomplish this

Re: List box selection

Anonymous — Wed, 05 Nov 2014 00:20:20 GMT

Hey,

there are many ways.

If the listbox values are static, you may create additional column in script using if statement(if (match(col1,'a','b','c'),col1)). use this column for list box.

if your values is dynamic and falling under certain scenario, you can use that condition to pick only those values into additoinal column and make use it for your list box.

If you really don't need these rows you can restrict them in dimension table it self in query using where clause.

Hope this helps.

Regards,

Chinna.

Re: List box selection

Wed, 05 Nov 2014 00:35:02 GMT

i would suggest to create filtering data in script

something like following should help see attached example:

OrigTable:

Load *

Inline [

Field, Group

a, 1

b, 1

c, 1

d, 2

e, 2

f, 2

];

/* get good field values filtering themselves */

NewTable:

LOAD Field as ParentField,

Field // child field to filter, links to existing data model

Resident OrigTable

Where Group = 1;

/* now produce all combinations (cartasian) of group 1 and 2 */

tmpTable:

LOAD Field as ParentField

Resident OrigTable

Where Group = 1;

Join(tmpTable)

LOAD Field

Resident OrigTable

Where Group = 2;

Concatenate(NewTable)

LOAD * Resident tmpTable;

DROP Table tmpTable;

Re: List box selection

Wed, 05 Nov 2014 00:39:05 GMT

the problem with this is, if i choose a then d,e,f do not get selected only a gets selected, my requirement is if a is selected then a,d,e,f should get selected or if b is selected then b,d,e,f is selected

Re: List box selection

Wed, 05 Nov 2014 01:05:41 GMT

Hi,

You can create field event trigger (OnChange) on this ParentField and make further selections on Field value itself