topic Re: Sub View in List box in QlikView

Sub View in List box

manoranjan_d — Mon, 26 Oct 2015 15:06:23 GMT

Hi all,

In my list box i have list of

suppose if user click on c , it has to display the sub view of C

example

if c clicked or selected then

it should show under c as

Re: Sub View in List box

marcus_sommer — Mon, 26 Oct 2015 15:08:26 GMT

For this you could use a dimension-group in drill-mode from your field and the subfields.

- Marcus

Re: Sub View in List box

manoranjan_d — Mon, 26 Oct 2015 15:10:08 GMT

in list box porpertied there is no dimension

Re: Sub View in List box

datanibbler — Mon, 26 Oct 2015 15:11:33 GMT

Hi,

another way would be to just create a second list_box with this subview_field and give it a visibility_condition so that it pops up only when one of the items has been selected in the other listbox (use GetselectedCount() for this)

HTH

Best regards,

DataNibbler

Re: Sub View in List box

Anonymous — Mon, 26 Oct 2015 15:12:14 GMT

I would define an expression

if (getselectedcount(field1)=0, field1, subfieldoffield1) // if nothing selected, Show field1 else subfield

// but if more than 1 selected it Shows subfield of both

if (getselectedcount(field1)=1,subfieldoffield1, field1 // if exacty selected Show Sub view, else Show field1

but for unselection you Need e.g. the current selection box

Re: Sub View in List box

marcus_sommer — Mon, 26 Oct 2015 15:17:01 GMT

You need to create such dimensions-groups within the document properties in tab "Groups" (you get this dialog, too within the dimension tab from charts within the bottom left) and then you could this dimension group choose like any other field within the field-dropdown.

- Marcus

Re: Sub View in List box

manoranjan_d — Mon, 26 Oct 2015 15:31:41 GMT

Hi datanibbler

can u attach ur file for my reference, bcoz i m new to qlikview.

Re: Sub View in List box

marcus_sommer — Mon, 26 Oct 2015 15:37:01 GMT

Have a look on this what are dimension groups and how they work: Creating Cycle and Drill Groups

- Marcus