topic Re: Search option not working on calculated dimension in QlikView

Search option not working on calculated dimension

Wed, 05 Mar 2014 07:12:22 GMT

Hi,

I have one list box in which I have written expression like

if(Flag=1,FSA name), It is showing the FSA name in listbox. But if I am searching FSA from search box and selecting some FSA ,its not selecting it from listbox.

Is the search option works on calculated listbox.

Thanks..!!

Re: Search option not working on calculated dimension

SunilChauhan — Wed, 05 Mar 2014 07:18:21 GMT

i thing it should but not for all FSA Data and as You are applying Flag=1 .

so some data would not come in calculated field.

Hope this helps

Re: Search option not working on calculated dimension

tresB — Wed, 05 Mar 2014 07:18:33 GMT

It would not get selected in the calculated list box, but would minimize(get highlighted as white) as 'possible values'.

Re: Search option not working on calculated dimension

Wed, 05 Mar 2014 07:29:21 GMT

It is showing in the current selections, But its not showing as green highlighted in list box.

Re: Search option not working on calculated dimension

tresB — Wed, 05 Mar 2014 07:37:54 GMT

Your calculated list box values are limited by Flag=1. Say there is a value FSA1 for both the flag 1 and 0. Now if you search it in the search box and select, it's scope remain both for flag 1 and 0, while your list box FSA1 if limited to flag=1, hence the selection scope is different for both these values. So it's logically fair that it does not get selected.

Re: Search option not working on calculated dimension

whiteline — Wed, 05 Mar 2014 07:39:59 GMT

Hi.

You have to use set analysis to see excluded values.

=aggr(Only({<[FSA name]=, Flag={1}>} [FSA name]), [FSA name])

Re: Search option not working on calculated dimension

Wed, 05 Mar 2014 07:41:44 GMT

No,the thing is even the FSA which is with Flag 1 is selected, its not selecting it from list box. Basically, in this case it should select it from listbox.

Re: Search option not working on calculated dimension

tresB — Wed, 05 Mar 2014 07:52:29 GMT

You are right, I missed a bit. As the calculated list box if calculated with reference to another field, it would not get selected, rather it would show as 'possible values'. Had this calculation been done with reference to same field like:

=If(Data>200, Data) // same field Data (selection would work)

the selection would work.

=if(field1=1, field2) // different field reference (selection-like you want, would NOT work)