topic Re: Searchable expression not giving correct result in QlikView

Searchable expression not giving correct result

Mon, 13 Sep 2010 10:09:04 GMT

Hi,

I'm having problems getting the "searchable" setting for expressions, in for example straight tables, to work correctly. Hopefully someone can enlighten me about how it works.

I have a straight table with several dimensions. I have an expression giving me the percentage of successfully delivered orders:

sum(Delivered)/sum(Ordered)

In the presentation tab I´ve checked the "searchable" setting. I want to be able to sort the result acccording to different criterias, for example "less than 95%'.

I'm not getting the right correct results when doing a search though. Weird thing is that it kind of works. Let say I search for "<50%", it will give me all rows with less than 50% but additional to this a few results that are above 50%. Why is this? Where is my logic faltering? I´ve tried all different format settings and search strings.

Thanks in advance.

/David

Searchable expression not giving correct result

Mon, 13 Sep 2010 14:23:42 GMT

Hi,

Kindly attach the application.

Regards,

Raj Kishor

Searchable expression not giving correct result

Wed, 17 Aug 2011 10:34:11 GMT

Dear Raj,

I'm experiencing the same thing, is there any solution to this problem ?

Regards,

Alex

Searchable expression not giving correct result

kaushiknsolanki — Wed, 17 Aug 2011 10:53:13 GMT

Hi,

It works fine at my side.

Make sure that you remove ** before entering any search string.

Regards,

Kaushik Solanki

Re: Searchable expression not giving correct result

lironbaram — Wed, 17 Aug 2011 10:59:07 GMT

hei

look at attch application may be it will clearify some things

Searchable expression not giving correct result

Mon, 05 Sep 2011 12:01:05 GMT

Think I got the message,

many thanks,

Alex

Re: Searchable expression not giving correct result

agigliotti — Mon, 11 Nov 2013 15:29:50 GMT

Hi Kaushik,

I have the same issue as David using version 11.20 SR4 (build 12129)

Is this a bug ?

Please let me know.

Many Thanks

Best Regards

Re: Searchable expression not giving correct result

braham — Thu, 02 Jan 2014 09:13:32 GMT

HI,

I also experienced this problem. What I found was once you have searched for a specific value check what Qlikview has added to your selections. In my case Qlikview only added a select on the first dimension, not on all the dimensions. This resulted in records being listed that matched the only the first dimension's values irrespective of the values in the other dimensions. In my case the values that I was selecting on was the result of a count function with a set analysis and an aggr function. I was able to redesign the table to only have one dimension, which then worked perfectly.

regards

Braham