topic Using searchable expressions with alternate states in QlikView

Using searchable expressions with alternate states

Mon, 18 Apr 2016 08:11:34 GMT

Hi,

I have a straight table set up in an alternate state, and in this table I have multiple expressions that I want to be able to search on. So i've enabled the "Searchable" option for the expressions under the Presentation tab, however it isn't working as expected.

Whenever I search for something in an expression a green dot appears on the dimension fields, indicating that a filter has been applied, but there is no reduction in the records that are being displayed. When I try this on a table that does not have an alternate state applied to it, it works fine.

Is there anything I need to do with the settings of the table or in the expressions themselves to make this option work with the alternate state?

Re: Using searchable expressions with alternate states

kkkumar82 — Mon, 18 Apr 2016 08:39:23 GMT

Hi James,

I have tried in Qv 12 SR1 by having alternate states and not to a table but when I select a value I am able to see the table getting reduced by rows.

Can we share a pic of the table when you set it to alternate states.

Kiran Kumar

Re: Using searchable expressions with alternate states

Mon, 18 Apr 2016 12:46:25 GMT

Hi,

Some pictures are attached at the bottom of this reply.

I think i've found the cause of the problem, but I don't know how to fix it. In my report I have filters that I want to be applied over multiple different alternate states. So in each of the expressions i've added in a bit to point them to the selections made in the inherited state (which the list boxes are in). The style of expression i'm using is:

=sum({<Person=$::Person>} Amount)

The first image attached shows the search filter working when the expression is just summing up the amount with no modifiers. The second one shows it not working when using the expression above, even though it is displaying that some kind of filter is applied.

Re: Using searchable expressions with alternate states

sunny_talwar — Mon, 18 Apr 2016 12:50:27 GMT

Is your whole chart in alternate state? You specify in your expression that it needs to be filtered based on selection in inherited state for person. Why do you expect it to be filtered on the selection in alternate state then?

Re: Using searchable expressions with alternate states

kkkumar82 — Mon, 18 Apr 2016 12:53:44 GMT

I think you are using getfieldselections() for getting the selected values right, then use the fourth argument of this function which is the state of the field.

put the state name in ' '

Re: Using searchable expressions with alternate states

sunny_talwar — Mon, 18 Apr 2016 12:54:04 GMT

May be try this:

=Sum({[Alternate State] * <Person=$::Person>} Amount)

Re: Using searchable expressions with alternate states

kkkumar82 — Mon, 18 Apr 2016 12:56:21 GMT

getfieldselections ( FieldName [, ValueSep [, MaxValues [, State]]])

Re: Using searchable expressions with alternate states

kkkumar82 — Mon, 18 Apr 2016 12:57:59 GMT

sunny what is the use of

<Person=$::Person>

this one , can you elaborate

Re: Using searchable expressions with alternate states

sunny_talwar — Mon, 18 Apr 2016 13:04:31 GMT

In a chart which is in alternate state, you would expect it to only filter based on selections in an alternate state field. But in case you want it to filter based on a selection in inherited state you can use this particular syntax. Using this syntax, the expression will only filter based on selection in Person's field from inherited state. Person selection in alternate state won't filter anything.

Re: Using searchable expressions with alternate states

kkkumar82 — Mon, 18 Apr 2016 13:11:40 GMT

So in this case is it doing a intersection * between the Alternate state and selection in the inherited.

I mean this

{[Alternate State] * <Person=$::Person>}

Re: Using searchable expressions with alternate states

sunny_talwar — Mon, 18 Apr 2016 13:13:47 GMT

Almost right

Intersection between every selection in Alternate State (including Person) with Person selection in Inherited state (This is assuming that the chart is in Alternate State)

Re: Using searchable expressions with alternate states

kkkumar82 — Mon, 18 Apr 2016 13:15:44 GMT

Thanks Sunny for taking out some time in your busy schedule

Re: Using searchable expressions with alternate states

sunny_talwar — Mon, 18 Apr 2016 13:16:52 GMT

Why is everyone trying to pull my leg today .

Oh well, its that kind of a Monday

Re: Using searchable expressions with alternate states

Mon, 18 Apr 2016 15:46:48 GMT

I've looked into it and made changes similar to what you put here. The whole table was set to an alternate state so what i've done is to put this back into the inherited state and change the expression so only that is looking at the different state.

Now that i've made that change the filtering on the expressions is working, as is the filtering on standard list boxes