topic Search Object and Conditional Expression in QlikView

Search Object and Conditional Expression

Mon, 07 Feb 2011 16:04:06 GMT

Hope someone can assist me

I would like to allow users to search for a value in a field using the Search Object.

They should however only see values based on a certain condition

I tried to use the following formula in the List of Fields expression text box in the Search Box properties, but this did not work

=If(PD_PatModule_ModuleName = 'Casebook note', PD_CBMKeyword_TermValue)

Any ideas how I can get this right in the search object (without needing to use a macro)

Thanks a mil

Search Object and Conditional Expression

Miguel_Angel_Baeyens — Mon, 07 Feb 2011 16:20:49 GMT

Hello,

What I'd do is to create that "display field" in the script, so the filed used in the search object will only have the values for your condition, so in your load script, something like the following

Table:LOAD // Your fields here If(PD_PatModule_ModuleName = 'Casebook note', PD_CBMKeyword_TermValue) AS SEARCH_OBJECT_DISPLAYFROM Source

Then use the search object with this field.

Hope that helps.