topic variable containing search query in QlikView

variable containing search query

Thu, 07 Jan 2010 02:51:39 GMT

I'm trying to create a dynamic chart title that contains the search query/term used in a search object.

Is there a variable created by default that I can reference to do this? I cannot seem to find any info on this type of variable (if it exists) or figure out a way to include this filter term like I want.

Thanks in advance.

variable containing search query

Miguel_Angel_Baeyens — Thu, 07 Jan 2010 08:41:28 GMT

Hello John,

Knowing the dimensions of the object you are showing, you can title your chart something like (untested)

='Chart 1 ' & GetFieldSelections(Field1) & GetFieldSelections(Field2)

Hope this helps!

variable containing search query

Thu, 07 Jan 2010 17:21:09 GMT

Not quite what I am looking for as the GetFieldSelections (as I understand it) would return the selected values in a given field and not the query entered by the user to search across the values.

For an example of what I'm trying to do, suppose there's a search form against a list of states. If a user searches for "new", the returned selections would include New Hampshire, New Jersey, New Mexico and New York.

I am trying to customize the title of the chart to say something like "Data for states that include 'New'"

If I use the above suggestion, I would get each of the 4 state names and not the original search term.

Any ideas?

variable containing search query

prieper — Thu, 07 Jan 2010 21:51:59 GMT

Think that in this case you should create an inputbox, into which the user have to enter the searchstring. With a macro you then may filter for this string, using this variable. Likewise you then can pickup this variable and display in the title.

HTH
Peter

variable containing search query

stevedark — Thu, 07 Jan 2010 21:55:06 GMT

Hi John,

I would suggest trying the function GetCurrentSelections(' - '). There are a few parameters to it, which are explained in the help file. If you are only looking for the values of one of your selections you would need to do some string manipulation of the output, using mid and index etc.

Hope that helps,
Steve

variable containing search query

Wed, 20 Jan 2010 19:46:33 GMT

Steve, While this does not accomplish exactly what I was trying to do, this approach seems to be the closest that QV currently supports. I've opened a new feature request for consideration as a future enhancement.

Thanks for your insight.