topic input box and legend in QlikView

input box and legend

Fri, 09 Nov 2012 22:28:04 GMT

Hi, I've attached a word doc showing my issue. I have a separate sheet with input boxes where the user can key in dates and see 2 additional lines on each graph (see top screen shot). When the user doesn't choose to see the 2 additional lines, I want the legend to go away (see bottom screen shot). I have one graph that works fine ( bottom graph). I've spent hours studying the settings and can't figure out how to make the legend go away on all other graphs ( dozens ). Any suggestions? Thank you, Jim

Re: input box and legend

whiteline — Sat, 10 Nov 2012 07:57:08 GMT

Hi.

It seems that you have the values Actuals, Curr Fact, Past Fcast Per1 and so on as Dimension.

So you could have to create calculated dimension to filter some values:

=aggr(if(match(Dimension, 'Actuals', 'Curr Fact', 'Past Fcast Per1')>0, Dimesnion)), Dimension)

Or you could use set analysis in experssions instead to skip undesiered dimension values:

=Sum({$*$<Dimension={'Actuals', 'Curr Fact', 'Past Fcast Per1'}>} Value}

Re: input box and legend

Mon, 19 Nov 2012 19:43:09 GMT

well if the user doesn't key in a date for additional lines, then no additional lines will show. I just want the legend to dissapear if no additional lines are selected.