topic Re: List Box Modelling in QlikView

List Box Modelling

Fri, 12 Sep 2014 09:59:34 GMT

Hey there,

I have a field with a certain numer of Values, which I want to represent in a list box.

The clue is, that some fields should only be visible if a certain field of the list box is selected.

So I only show some fields at first which I selected by:

=if(Match(Field,'A','B','C','D','E','F'),Field)

Now I want to show fields G,H,I when I select C or D. I also want to be able to add further restrictions for other fields.

I hope you understand my issue an are able to help me

Best Regards and Thanks in advance

Alex

ecolomer — Fri, 12 Sep 2014 10:03:25 GMT

Here you have an example

Is this?

Fri, 12 Sep 2014 10:43:58 GMT

Hey Enrique,

I like to select another Field Value in the second box, so there should be E,F,G in this box.

Best case would be one object, which shows the new Values when certain fields are selected,

ecolomer — Fri, 12 Sep 2014 10:59:14 GMT

I think you do not quite understand what you want.

You can simulate it in excel and I spend at least image

(sorry but my English is not good)

Fri, 12 Sep 2014 11:08:18 GMT

Do you want to show the G,H,I in other list box, when you select C or D.

Fri, 12 Sep 2014 11:10:02 GMT

If it is the only solution then yes.

Otherwise it would be great to see it in the same box.

ecolomer — Fri, 12 Sep 2014 11:16:41 GMT

This?