topic Re: searchable in straight table not working in QlikView

searchable in straight table not working

stonecold111 — Wed, 25 Nov 2020 16:16:04 GMT

Hi qliksss

I am attaching both xls and qvw file

i have one expression for which i enabled searchable. but i wen i give <0 . it is giving positive value also 4599

this is sample data. like this i am getting so many positive values for <0 and so many negative values for >0

what could be the reason. is there anyway that i can get >0 and <0 values accurately

for <0

` `press enter then

measure 4599 is coming for <0 .... Plz suggest qlikssss

Thanks in advance

Re: searchable in straight table not working

stonecold111 — Sun, 26 Mar 2017 15:59:30 GMT

stalwar1‌

sunny help me

Re: searchable in straight table not working

stonecold111 — Sun, 26 Mar 2017 16:14:07 GMT

jagan‌

swuehl‌

help me

Re: searchable in straight table not working

Anil_Babu_Samineni — Sun, 26 Mar 2017 16:16:03 GMT

In fact, You should not use the Wild card like *<0*. It should be <0 and i am not sure why do you need -1 over the expression. I've removed and applied it's working

(sum(colum1)-sum(column2)-sum(column3))

Re: searchable in straight table not working

stonecold111 — Sun, 26 Mar 2017 16:31:15 GMT

yes i am using <0 only not *'s

and i need -1 in my expression. i need that in my expression. what is the problem with that -1

it just changes positive to negative. stiill qlikview should filter . don;t ask me to remove -1

anyway thanks

Re: searchable in straight table not working

Anil_Babu_Samineni — Sun, 26 Mar 2017 16:42:32 GMT

May be straight table recognize the -ve values because of -1. I thought so.

don;t ask me to remove -1

Why Should I, That is your project. I am asking about what is the use of -1 over there

it just changes positive to negative

Is there any requirement to get +ve to -ve values or for formality you have written over there? If so fine. Anyway wait some time may be experts reply to you

Re: searchable in straight table not working

stonecold111 — Sun, 26 Mar 2017 16:49:57 GMT

yes . my requirement is to get positive and negative values for that expression.

i don't know why qlikview can't give correct results for basic expression

Re: searchable in straight table not working

swuehl — Sun, 26 Mar 2017 16:52:39 GMT

The reason why you get an 'incorrect' filter is due to the fact that selections are made on dimensional field values, not on the expression values.

If you look at the dimensional values related to negative measure, you'll notice that the line with 4599 shows also dimensional values that appear in any other line with negative measure.

To overcome this, you would need to make your dimensions a primary key.

Re: searchable in straight table not working

stonecold111 — Sun, 26 Mar 2017 16:57:17 GMT

Plz explain briefly. how to make dimension a primary key

Re: searchable in straight table not working

stonecold111 — Sun, 26 Mar 2017 17:01:01 GMT

and why selections are made on dimensional fields when i am searching in measure filed

Re: searchable in straight table not working

stonecold111 — Sun, 26 Mar 2017 17:02:18 GMT

and why selections are applied on fields when i am searching in my measure

Re: searchable in straight table not working

swuehl — Sun, 26 Mar 2017 17:21:31 GMT

LOAD AutoNumberHash256(name,id,desc,group) as Key,

name,

id,

desc,

group,

colum1,

column2,

column3

FROM

[HI.xls]

(biff, embedded labels, table is Sheet1$);

Add Key field to your dimensions (you can hide the column on presentation tab).

Re: searchable in straight table not working

bouderbc — Sun, 26 Mar 2017 18:06:44 GMT

Dimension : Year

Measure: sum (sales)

Needs 1: N and N-1 in the same Graph

---------2: N and the 13 th Month

Thanx Omar for ur help !

Re: searchable in straight table not working

stonecold111 — Mon, 27 Mar 2017 06:39:05 GMT

Hi Stefan,

If i give autonumberhash function it is changing my measure values .

now its giving different values. this is just sample data

Now >0 and <0 working .. but values for measure field is showing different values

is there any other way

Re: searchable in straight table not working

stonecold111 — Mon, 27 Mar 2017 07:03:02 GMT

Ok. Thanks.. working fine