topic Re: Conditional show/hide sheets on multi selection in QlikView

Conditional show/hide sheets on multi selection

Tue, 31 Jul 2012 07:28:11 GMT

Hi,

is it in anyway possible to show/hide sheets when the user selects more than 1 value?

Currently I have a main category in a list box of which only 1 value at a time can be selected.

However now I'd like to add subcategories based on the selected main category, allowing the user to select more than one subcategory at a time.

category 1

subcategory1 -> shows sheet 1

subcategory2 -> shows sheet 2

subcategory3 -> shows sheet 3

category2

subcategory1 -> shows sheet 4

subcategory2 -> shows sheet 5

...

This works perfectly, when the user selects a main category and only 1 subcategory.

But since there can be more than one subcategory selected at a time, the conditional show for the sheet won't work any longer as soon as 2 or more subcategories are selected.

Has anyone got any idea on this?

Cheers,

Erwin.

Re: Conditional show/hide sheets on multi selection

Jason_Michaelides — Tue, 31 Jul 2012 07:31:06 GMT

I guess your show condition includes something like:

Category2='Subcategory1'

Instead, try using Index():

Index(Category2,'Subcategory1')

Hope this helps,

Jason

Re: Conditional show/hide sheets on multi selection

Anonymous — Tue, 31 Jul 2012 07:36:13 GMT

Hm, for Sheet1 you could use something like:

if(index(concat(subcategoryfield,','), 'subcategory1')>0,1,0)

Basically concatenating the values in your subcategoryfield and checking if the subcategory1 value is part of the concatenated list.

Re: Conditional show/hide sheets on multi selection

Anonymous — Tue, 31 Jul 2012 07:36:35 GMT

Looks like Jason beat me to it

Re: Conditional show/hide sheets on multi selection

Tue, 31 Jul 2012 08:09:59 GMT

Thanks for the help, this works perfectly!