topic Pass multiple Input Box values into Expression in QlikView

Pass multiple Input Box values into Expression

Wed, 23 May 2012 19:41:24 GMT

Hi, I have an input box where users enter a value and I pass the value into an expression in many charts. Can I have the user input multiple values into the input box and pass the multiple values into my expression? Here's what I have now.

sum({$<FORECASTID={"$(INPUTBOXVALUE)"}, LevelName = { 'Assets' }>}AvgBal

Pass multiple Input Box values into Expression

chematos — Wed, 23 May 2012 20:02:08 GMT

Hi,

have you tried to write that values into the inpunt box separated by commas??

if sum({$<FORECASTID={"$(INPUTBOXVALUE)"}, LevelName = { 'Assets' }>}AvgBal is not working, you could try this:

sum({$<FORECASTID={'=$(=Subfiled($(INPUTBOXVALUE),','))}, LevelName = { 'Assets' }>}AvgBal

hope this helps.

Regards,

Chema

Re: Pass multiple Input Box values into Expression

Wed, 23 May 2012 20:17:00 GMT

no luck with that one…. I wish I could put an “in” in my set analysis line. Jim

Re: Pass multiple Input Box values into Expression

chematos — Wed, 23 May 2012 20:46:22 GMT

Sorry, function subfield needs the number of each field in the list .... good luck

Re: Pass multiple Input Box values into Expression

Thu, 24 May 2012 20:29:41 GMT

Thanks for the effort, actually you’ve given me an idea to go in a different direction. Jim

Re: Pass multiple Input Box values into Expression

Mon, 25 Jun 2012 12:55:38 GMT

Hi jfrancisco,

How did you get on?

Thanks

Re: Pass multiple Input Box values into Expression

Mon, 25 Jun 2012 12:55:55 GMT

Hi jfrancisco,

How did you get on?

Thanks