Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pass multiple Input Box values into Expression

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

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

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

View solution in original post

6 Replies
Highlighted
Specialist II
Specialist II

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

View solution in original post

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Not applicable

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

Highlighted
Not applicable

Hi jfrancisco,

How did you get on?

Thanks

Al

Highlighted
Not applicable

Hi jfrancisco,

How did you get on?

Thanks

Al