topic Re: Assign search object result to a variable in QlikView

Assign search object result to a variable

Thu, 24 Apr 2014 14:01:12 GMT

Is it possible to take a result from a search object -- i.e. Employee_ID, and assign that value to a variable. I'm wanting to populate a chart with data based on a value from a search.

Re: Assign search object result to a variable

Thu, 24 Apr 2014 14:06:35 GMT

a search will generally apply a filter an input box would be a variable by default?

Re: Assign search object result to a variable

Thu, 24 Apr 2014 14:51:53 GMT

What if I want to restrict a chart's values to only those corresponding to the selected object, and show it with no values until one is entered?

Re: Assign search object result to a variable

Anonymous — Thu, 24 Apr 2014 15:06:12 GMT

i think you are looking for an input box. assign the value of input box to a variable and use that variable in a set analysis in your expression in the chart something like below:

input box is set to variable vUseProfile. when a user enters a string, it is compared to Use Profile and provides the result accordingly. of course, you will have to modify this to your specific requirement or provide a sample qvw and i can help you.

expression in chart:

count({<[Use Profile]={'$(vUseProfile)'}>}[Customer ID])

Re: Assign search object result to a variable

nagaiank — Thu, 24 Apr 2014 15:10:57 GMT

You may use a calculation condition in the General tab of the object Properties window, such as

GetSelectedCount(yourfieldname) <> 0

Re: Assign search object result to a variable

Thu, 24 Apr 2014 15:15:22 GMT

that is EXACTLY what I needed, thank you.